Question
2
Replies
140
Views
RBC
Posted: March 20, 2017
Last activity: March 27, 2017
Closed
VBA script with buttons in excel: How do I cause a click event..?
Have a user with a VBA form built in Excel (2010). the user fills some fields then clicks a button on the VBA form. I'm having trouble inspecting and finding the click event for the VBA form. How can I cause the click to happen without modifying the VBA form, which is not accessible to the developer (ME!)
Any input is appreciated...
regards,
Rob
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Thanks for the honesty.. Was hoping for something, but not surprised...
Rob
VBA Forms are not supported. One way I have seen to get around this limitation is to add an event handler in VBA to a button and have it open a Message Box which you should be able to interrogate and then close. If you can't get into the VBA I think you may be stuck.