jackson1990
Board Regular
- Joined
- Feb 21, 2017
- Messages
- 56
So, I have 5 or so buttons I want clicked all at once. They are all the same macro, but based on the location of the button they pull different data. They are all form control buttons, so I was wondering how I would go about making a button that would click all 5? I thought maybe the call function but that only seems to work with Macro's, and since the macro depends on placement in the excel that doesn't work. Is there a way to click all 5 form control buttons via VBA?
For this example, say the form buttons are Button 24, Button 27, Button 28, Button 29, Button 30
Thanks in advance everyone!
For this example, say the form buttons are Button 24, Button 27, Button 28, Button 29, Button 30
Thanks in advance everyone!