Microsoft excel vba Selecting/Coloring cells

Ultimate Windows 7 ultimate 64-bit
January 20, 2011 at 20:23:34
Specs: Windows 7, 1 Gig
ok i am NEW to VBA but i am sorta failure with 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
Sheets("QC Form").Select
Range("E10").Interior.Color = RGB(8, 255, 44)
End If

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

See More: Microsoft excel vba Selecting/Coloring cells

Report •

January 21, 2011 at 14:17:53
ok sorry i cookie and fudged up the reason i was getting this error was because i needs to be this line of code instead:
Sheets("QC Form").Range("E10").Interior.Color = RGB(8, 255, 44)

it works wonders

Report •
Related Solutions

Ask Question