ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,199
- Office Version
- 2007
- Platform
- Windows
Hi,
Ive been trying without luck for the last hour to change the cells interior colour to vb green once it’s been selected from the partial code shown below.
The full code allows me to select from ComboBox1 & the selection is then A-G row 4
My cells are all yellow but I would like the selected cell to become vb green.
After the .Select below I’ve tried,
Interior.color = vb green
ColorIndex = vb green
ActiveCell.Color = vb green
I don’t click the cell because the code selects the cell so I can apply it to the worksheet change event.
None of the above work, can you put my mind at rest please.
Have a nice day.
Ive been trying without luck for the last hour to change the cells interior colour to vb green once it’s been selected from the partial code shown below.
The full code allows me to select from ComboBox1 & the selection is then A-G row 4
My cells are all yellow but I would like the selected cell to become vb green.
After the .Select below I’ve tried,
Interior.color = vb green
ColorIndex = vb green
ActiveCell.Color = vb green
I don’t click the cell because the code selects the cell so I can apply it to the worksheet change event.
None of the above work, can you put my mind at rest please.
Have a nice day.
VBA Code:
If ComboBox1 = "VIN NUMBER" Then
Range("A4").Select
ElseIf ComboBox1 = "VEHICLE" Then
Range("B4").Select
ElseIf ComboBox1 = "CUSTOMER" Then
Range("C4").Select