Hi Team,
I'm attemping to assign a Macro that has multiple parameters to an image in Excel 2003.
It works with one parameter, but as soon as I add a second it can no longer find the macro.
Example of what works:
'MacroName("Parameter1Value")'
' Function to open the correct UserForm.
Sub OpenUserForm(UserFormName)
' Show the UserForm
VBA.UserForms.Add(UserFormName).Show
End Sub
Example of what doesn't work:
'MacroName("Parameter1Value", "Parameter1Value")'
' Function to open the correct UserForm.
Sub OpenUserForm(UserFormName, UserAction)
' Prepare the UserForm
PrepareUserForm (UserAction)
' Show the UserForm
VBA.UserForms.Add(UserFormName).Show
End Sub
Bookmarks