Thanks.
I am using Mac, and it can't open the UserForm in design view.. So I can't apply your suggestion.
How do you find the UserForm name in the code?
I only have this in Form Initialize stage
Private Sub UserForm_Initialize()
With TemplateName
.AddItem "Template 1"
.AddItem "Template 2"
.AddItem "Template 3"
.AddItem "Template 4"
.AddItem "Template 5"
.AddItem "Template 6"
End With
End Sub••••ˇˇˇˇ
|