Hi all, I would like to run a userForm with a specific name from a Module. Here is the code for my userForm.
I found a code online which uses UserForm(name of userForm).Userform_Initialize.
It calls out the code above, but I get a return type mismatch.
Code:
Public Sub UserForm_Initialize()
'Adding the Options for fileDecision comboBox
With fileDecision
.AddItem "Append"
.AddItem "Copy"
End With
'Adding the Options for headerExist comboBox
With headerExist
.AddItem "Yes"
.AddItem "Default"
.AddItem "No"
End With
End Sub
I found a code online which uses UserForm(name of userForm).Userform_Initialize.
It calls out the code above, but I get a return type mismatch.