| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Color of Cell
Hi Nigel
This works but needs to be placed in the ThisWorkbook object. Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Range("A1:M20").Interior.ColorIndex = 0 Target.Interior.ColorIndex = 7 If Left(Target, 5) = "Sheet" Then Sheets(Target.Value).Activate End Sub Regards Andrew Bourke Nigel Bennett wrote: I would like to change the color of the active cell to a specified color when the focus is in that cell and then when it moves to another revert to white. also if the cell has another sheet name in it that when the user selects that cell the active sheet is changed to the new sheet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot change font color or cell color | Excel Discussion (Misc queries) | |||
| Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| Browse Forms Controls and change TextBox color based on cell color | Excel Programming | |||
Threaded Mode
