Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight Cell
Hit ALT-F11 in Excel, there are 2 dropdowns near the top, make the left one
worksheet, and change should be auto selected, if not change the second dropdown -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "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) |