Posted: 20 Mar 2017 17:37 EDT Last activity: 27 Mar 2017 14:24 EDT
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!)
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.