How to call a sub using a variable

Hi,

I'm trying to create a kind of menu, listing all the available macros we have, so my users can pick the one they want to execute.

I've put all the macros name with the sub to call in a picklist. when the user select a macro, I'm trying to call the associated function but a "Call myFileName" does not work.

I've seen some notes in various web side suggesting to use "Application.run" but I receive a "Run-time error '438' - Object doesn't support this property or method). I think this will only work for Excel, Word and Access...

I'm running out of idea now so any trick would be appreciated?
#Reflection