View Single Post
 
Old 07-17-2024, 11:38 AM
annguye2 annguye2 is offline Mac OS X Office 2021
Novice
 
Join Date: Jul 2024
Posts: 22
annguye2 is on a distinguished road
Default

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••••ˇˇˇˇ
Reply With Quote