open a userform using the userform name that is not userform1 or 2 or 3....

[still learning]

Hi,
I changed the name of the Userform to Vender
How do I change this macro to open it

Sub ordersusf()
Application.Goto Reference:="R1C1"
UserFormVender.Show
End Sub

I know I can change the name back to Userform1, but I'm curious as how to do it if I name it different

(excel 365)


mike

 

[kevin9999]

Perhaps try

Load Vender
Vender.Show

 

[still learning]

Hi kevin9999,
Yep.. that works
Thanks for the help
I kept trying to use the word Userform in every thing I tried

mike

 

[kevin9999]

Hi kevin9999,
Yep.. that works
Thanks for the help
I kept trying to use the word Userform in every thing I tried

mike

Happy to help Mike.