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.
Posted: 5 years ago
Posted: 27 Mar 2017 14:24 EDT
Robert Fleming (RobIsTheName)
Senior Manager, Process Automation