|ok i am NEW to VBA but i am sorta failure with VB.net their like the same so... |
in Microsoft excel i have a little form which will have the user choose between FAIL or PASS.
. I have a small if statement that will check if pass is checked and if it is it will color cell "E10" green that is in a different data sheet the code is:
If Me.grpLineofsightPass.Value = True Then
Range("E10").Interior.Color = RGB(8, 255, 44)
but what it will do is color the cell E10 in the data sheet that the button click event procedure is in...i have no clue what the proper code for that is so...and also thank you in advance. =D