Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight Cell
Gordon
Right-click on the sheet tab and "View Code" Copy/paste the code into that sheet module. Note: as written, John's code will place a red border around every cell you select on the sheet and leave that border there. Is that what you wanted? Or perhpas you just wanted the selected cell highlighted so's you can tell which cell is selected? Gord Dibben MS Excel MVP On Wed, 27 Dec 2006 12:52:01 -0800, Gordon wrote: Hi... Sorry, not too clever here. Could you tell me how I would do a worksheet selection change? Thanks in advance...Gordon... "John Bundy" wrote: Do a worksheet selection change and add this, change border style as needed Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveCell.Borders.ColorIndex = 3 ActiveCell.Borders.LineStyle = xlDouble End Sub -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Gordon" wrote: Hi... I need some code that will change the formatting of a cell when selected. I simply want an emboldened red border around the cell selected. Sounds easy but I've become a head scratcher! Thanks Gordon... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
Highlight Cell Based Upon Referenced Cell Data | Excel Worksheet Functions | |||
I can't see Highlight cell in Find & Replace Cell | Excel Discussion (Misc queries) | |||
click on one cell to find and highlight a related cell? | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |