Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Robert Fleming (RobIsTheName)
RBC
Senior Manager, Process Automation
RBC
CA
RobIsTheName Member since 2017 32 posts
RBC
Posted: Mar 20, 2017
Last activity: Mar 27, 2017
Posted: 20 Mar 2017 17:37 EDT
Last activity: 27 Mar 2017 14:24 EDT
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

To see attachments, please log in.
Robotic Process Automation

Posted: 7 years ago
Posted: 21 Mar 2017 21:03 EDT
Jeff Badger (jeffbadger)
PEGA
Principal Product Manager, Robotics
Pegasystems Inc.
US

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.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice