Executing a Macro with Variable Name from String

Hi Again Team,

I'm trying to execute a macro based on the value of a string.

Does anyone know how this could be done?

I have this so far:

' Function to open the correct UserForm.
Sub OpenUserForm(UserFormName As Variant, UserFormAction As Variant)
'   Prepare the UserForm
    MacroName = "PrepareForm" & UserFormAction
    MacroName (UserFormName)
'   Show the UserForm
    VBA.UserForms.Add(UserFormName).Show
End Sub

Application.Run macroname, userformname

should work, although I'm not sure what your macro would do that didn't involve loading the form, which you then do again.