Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shading a cell based on another cell with not value
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
shading a cell based on another cell with not value
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 "Tony" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill a cell based on a condition being met | Excel Worksheet Functions | |||
Referencing a cell based on the value in another cell | Excel Discussion (Misc queries) | |||
HELP| populate cell with particular value based on multiple condit | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |