Hi,
I want to know how to put the same click event for various command button.
e.g.
Similarly i am having 30 command buttons for which i need to set the same msgbox.
Please Login or Register to view this content.
My question here is, how to set the click event for all the command buttons, without going to the individual button click event?.
Is there a way to give generic event for all the command buttons
Last edited by Leith Ross; 03-15-2011 at 01:48 AM. Reason: Edited Code Tags
You need a Class module to achieve this.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks for the help, it working fine now
One question we can set the common event for label as well by using class event?
and for any of the object?
Why would you want an event for a label?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks