Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i change the color of a cell when tabbing?
How do i change the color of a cell when tabbing so it's easier to move
around spreadsheet knowing where the cursor is located? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i change the color of a cell when tabbing?
You could try Chip Pearson's RowLiner add-in, available he
http://www.cpearson.com/excel/RowLiner.htm Hope this helps. Pete On Dec 18, 2:36*pm, Lisa Z <Lisa wrote: How do i change the color of a cell when tabbing so it's easier to move around spreadsheet knowing where the cursor is located? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i change the color of a cell when tabbing?
Copy the code below to a given worksheet codemodule. Once you do it
and save the excel workbook, on that particular sheet you would see the cell graying out when you tab or move between range or cells. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim mySht As Worksheet Set mySht = Target.Parent mySht.Cells.Interior.ColorIndex = 0 Target.Interior.ColorIndex = 15 End Sub I hope this helps... Selva V Pasupathy For more on Excel, VBA, & other Resources Please visit: http://socko.wordpress.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
Can you change the color of one cell based on the color of another | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) |