Automation with Excel 97 and VB (Desperately seeking help)

Anirban
Anirban used Ask the Experts™
on
Help!!! I am creating a custom CommandBarButton in Excel 97 from a VB application and I need to capture the click event for the CommandBarButton which I created. How would I capture the click event without a macro ??

Any help would be highly appreciated

Cheers
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can do so with VBA code instead of a macro.

Choose View...Toolbars...Control Toolbox.  Add a button on the spreadsheet and click the view code button in the Control Toolbox.  Put your code in the click event.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Recommendation: Accept comment from Twalgrove
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

DominicCronin
EE Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial