View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ray Costanzo [MVP] Ray Costanzo [MVP] is offline
external usenet poster
 
Posts: 22
Default simulating click events

You can just call the subroutine. Since the click sub has private scope
within the sheet code, you'd have to call it from in there.

Another option, a better one imo, would be to put the code into its own sub
elsewhere and just have the click event call that subroutine.


--

Ray at work
Microsoft ASP/ASP.NET MVP


"ben" wrote in message
...
simple question

Is there a way to simulate the clicking of a control through vba?

eg..
Sheet1 contains a label named 'l12' and will change colors when clicked,
is there a way to cimulate actually clicking it so that the code for its
event is triggered?