how do you make the cursor position have a color ?

E

Erin Nordan

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing from Word my Inserted Pictures colors are dull and lack color 0
AppleScript - How do I select a text ? 1
Converting URLs in comments to Markdown-formatted links 2
View jumps back to cursor position when scrolling in Word 2007 1
Paragraph numbering in Word 1
How do I convert shading to highlighting for specific colors 8
Need help modifying code 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1

Top