| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection_Activate
Hi,
I have seen code for Private Sub Worksheet_Change which allows code to be excecuted as a result of a change to a cell but is there anything that can identify when a cell is simply selected? -- Andrew |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selection_Activate
Hi,
Try this: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Me.[A1]) Is Nothing Then _ MsgBox "Hello World!" End Sub Regards, KL "Andrew" wrote in message ... Hi, I have seen code for Private Sub Worksheet_Change which allows code to be excecuted as a result of a change to a cell but is there anything that can identify when a cell is simply selected? -- Andrew |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selection_Activate
Look at the Worksheet_SelectionChange event.
-- Vasant "Andrew" wrote in message ... Hi, I have seen code for Private Sub Worksheet_Change which allows code to be excecuted as a result of a change to a cell but is there anything that can identify when a cell is simply selected? -- Andrew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
