Thread: On Click Event
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Craig Craig is offline
external usenet poster
 
Posts: 208
Default 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