shading a cell based on another cell with not value

[Guest]

I'm making an application where the user will tab through cells. Each cell
has a description of that cell beside it in a different cell. How can I
shade the cell with the description when the user tabs into the cell it is
describing, and then have it un-shade when they tab out of it?

 

[Guest]

hi,
not sure exactly but try something like this....

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = 0
ActiveCell.Offset(0, 1).Interior.ColorIndex = 6 'yellow
End Sub

if you are unsure, look up the offset property in vb help.
colorindex...0 = white, 1 = black. play with the numbers until you get your
color.

regards
FSt1