Call Macros from Userforms

[Jietoh]

Hello All and Happy New Year!

I've been using the below line to run a macro from a userform for the past 2 years without issue. Now it suddenly stopped working.

Please Login or Register  to view this content.

This line is written into the code for the Userform, and the macro "Full_List_Macros" is saved in a module in the same workbook. I know its not a problem with the macro, cause when I bypass the Userform and activate the macro everything works fine. So its just activating the macro from the command button that is the issue.

Any thoughts?

Dan

[LJMetzger]

Hi Dan,

You may have changed the workbook name.

If the Macro is in the same workbook the following should work:

Please Login or Register  to view this content.

Lewis

[Jietoh]

Thanks. That didn't help, but I finally figured out the issue. I recently renamed the entire module to "Full_List_Macros". So now there was a module and a macro with the same name and the command didn't know what to do. I changed the name on the Module and everything works.

Thanks though!

[LJMetzger]

Your welcome. You have to be very careful with names and duplicates can cause problems as you discovered. To avoid the problem I start all my module names with the letters 'Mod'.