I have a workbook containing some SLA measures & a user form.
Depending on what options the users picks I'd like to build/concatenate the a macro name to be called
I've managed to build the macro name & store it in a variable
But I can't figure out how to call it?
For instance the macro name is M10, and I have confirmed it is stored in variable 'MacroName' by using a MsgBox to display the contents
When I use 'Call M10' it executes no problem. But when I call MacroName.Value I get an error - 'Compile error: Invalid qualifier?
Any help appreciated
Please Login or Register to view this content.