In VBA, I want to call the Click event of a control on another worksheet...
Posted by Tuc on May 22, 2001 9:15 AM
In VBA, I want to call the Click event of a control on another worksheet.
Now ordinarily, I could put in code something like
Sheet4.CheckBox1_Click (provided that I had made the click event public)
What I want to be able to do is to refer to the worksheet a little bit more dynamically. Something like: