View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default highlight the current cell

Right click on the sheet tab, select view code, and put in code like this:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6
End Sub

Note that this clears the clipboard and clears the undo stack as I recall,
so you will not be able to paste or undo.

--
Regards,
Tom Ogilvy

"D" wrote in message
...
I would like to be able to have the current cell highlighted in Excel.

This
would change based on my cursor position. I think I have seen this before

but
I cannot find it now. Thanks for the help.