Running macros from drop down box on user form 3

[teebird]

Hi

Excel 97 - I would like to have all my macros appear in a drop down box on a form and when the user selects one - the marco will run.

Tee

 

[rmikesmith]

Tee,

and anyone else interested. I've put together a workbook to do what you want. It contains a userform with a dropdown that lists the macros in the workbook. Once selected, the macro is run by clicking a command button on the form. It's probably easiest to send this out to those interested. Just post your email address. If you really want me to post the code, I can.

BTW, this procedure recognizes (and lists) as "macros" only those Subs that take no parameters (just as Excel itself does). It also excludes itself from the listing.

Regards,
M. Smith

 

[xlbo]

Hi Mike - wouldn't mind a copy if that's ok
Geoff.Barraclough@PunchPubs.co.uk
Cheers Rgds
~Geoff~

 

[teebird]

Hi Mike

Many thanks for your reply.

email is: teebird@austarnet.com.au

Regards Tee

 

[xlbo]

Havce a star m8 - very nice bit o' code
Mike or Robert ??
Apologies for calling you Mike for ages if it is Rob %-) Rgds
~Geoff~

 

[rmikesmith]

Thanks Geoff --

No need to apologize... It's Mike (a guy's gotta have an alias or two )

Regards,
Mike

 

[DeLaMartre]

Hello Mike,

If you have the time, I would very much appreciate a copy of the workbook you mentioned above.

excelclass@hotmail.com

Thanks very much! -Bob in California

 

[DaleWatson123321]

Hi Mike,

This sounds like a good routine to have in my library.

Sure will appreciate a copy.

Thanks. ...Dale Watson dwatson@bsi.gov.mb.ca

 

[DaleWatson123321]

Thanks, Mike. It's appreciated, and worthy of a STAR.

Regards, ...Dale

 

[ddeegan]

Hello

I would appreciate a copy
Thanks in advance
Dave

DDeegan@asicentral.com

 

[methoni]

I would love a copy as well..
Thanks in advance.

demitrius.Triantafylidis@ahlstrom.com

or methoni7@aol.com

 

[DeLaMartre]

Thanks for the code, Mike. You deserve another STAR! -Bob in California