Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
On Click Event
Is there an event in Excel VBA where I can trigger an event when the user
selects a cell? Sort of like an oncurrent event in Access, where an event is fired when the user clicks on a cell. As the user selects cells, I want an event to fire based on the activecell's value or contents. I know there is a Worksheet_Activate event - I'm looking for a Cell_Activate event. Thanks. -- Craig |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
On Click Event
Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "Something just changed, time to act!" End Sub or Private Sub Worksheet_SelectionChange(ByVal Target As Range) MsgBox "A new cell has been selected, maybe act here?" End Sub One of the two is bound to be what you are after... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
On Click Event
The Worksheet_SelectionChange(ByVal Target As Range) event may work for you.
"Craig" wrote: Is there an event in Excel VBA where I can trigger an event when the user selects a cell? Sort of like an oncurrent event in Access, where an event is fired when the user clicks on a cell. As the user selects cells, I want an event to fire based on the activecell's value or contents. I know there is a Worksheet_Activate event - I'm looking for a Cell_Activate event. Thanks. -- Craig |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
On Click Event
Thank you...
-- Craig "William Horton" wrote: The Worksheet_SelectionChange(ByVal Target As Range) event may work for you. "Craig" wrote: Is there an event in Excel VBA where I can trigger an event when the user selects a cell? Sort of like an oncurrent event in Access, where an event is fired when the user clicks on a cell. As the user selects cells, I want an event to fire based on the activecell's value or contents. I know there is a Worksheet_Activate event - I'm looking for a Cell_Activate event. Thanks. -- Craig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help Using Click Event | Excel Programming | |||
Click event to run only once | Excel Programming | |||
Click event to run only once | Excel Programming | |||
On Click Event?, and how to use | Excel Programming | |||
Click Event | Excel Programming |