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?
|