| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Single click event
I would like to change the colour of a cell whenever it is
selected either through the keyboard or with a mouse click (Single Click) Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Single click event
Open the vb editor and double click on the workbook and add the following
code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Target.Interior.Color = 65535 End Sub change the 65535 (which is yellow) to whatever color you want... "isy Taman" wrote in message ... I would like to change the colour of a cell whenever it is selected either through the keyboard or with a mouse click (Single Click) Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change syperlink from single click to double click | Excel Worksheet Functions | |||
| Is Multi click Event possible? | Excel Discussion (Misc queries) | |||
| On click button event | Excel Worksheet Functions | |||
| Click event on Scrollbar | Excel Programming | |||
| Mouse Click Event | Excel Programming | |||
Hybrid Mode
