how do you make the cursor position have a color ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to be able to locate when my cursor is located in a spradsheet
easier by coloring the highlighted cell it is at. How do I accomplish this?
 
You would need VBA code to produce this.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6
Oldrow = Target.Row
ws_exit:
Application.EnableEvents = True
End Sub

Thsi is woeksheet event code.

Right-click on the sheet tab and "View Code"

Copy/paste the code into that module.

Colorindex 6 is yellow.

To see the rest of the colors and numbers see David McRitchie's site.

http://www.mvps.org/dmcritchie/excel/colors.htm


Gord Dibben MS Excel MVP


On Fri, 22 Sep 2006 10:30:02 -0700, Erin Nordan <Erin
 
Back
Top