Code to rationalise multiple command buttons in VBA

**newbi004** · 11-16-2012, 05:25 AM

Hi there

Would anybody be able to advise me on my problem?

I have 63 command buttons on a userform in multipage controls. Each command button, when clicked, does almost the same thing. For example:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

and so on. Is there a way to create a sub which will recognise the name of the command button, eg 2_1_1 for cmd 2_1_1 and 2_1_2 for cmd2_1_2 so that I can call that sub to execute the code? There is a different caption name for each button.

Thanks all.

**newbi004** · 11-16-2012, 06:40 AM

Any thoughts? I wonder if an event handler is the answer. Help!

**Kyle123** · 11-16-2012, 07:02 AM

I'd create an Event Handler because I couldn't be bothered adding code to each command button, but if you don't feel comfortable with classes, you might get away with something like:

Please Login or Register  to view this content.

If you're interested, the event handler class would look something like:

Class CbtnHandler:

Please Login or Register  to view this content.

Form implementation:

Please Login or Register  to view this content.

This approach would need no code in the button click subs

**newbi004** · 11-16-2012, 07:48 AM

Wow! When am I going to get to this level of understanding! (probably never...)

Kyle, thanks for these options. I will try them out.

Code to rationalise multiple command buttons in VBA

LinkBack

Thread Tools

Rate This Thread

Display

Code to rationalise multiple command buttons in VBA

Re: Code to rationalise multiple command buttons in VBA

Re: Code to rationalise multiple command buttons in VBA

Re: Code to rationalise multiple command buttons in VBA

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions