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