R
Rock
I have 9 different UserForms and I can call any specific UserForm with the
macro below. (Imagine any number where the question mark is)
Sub ShowUserForm()
UserForm?.Show
End Sub
What I would like to do instead is have a macro that will call a different
random UserForm from this list below each time I activate it.
UserForm1
UserForm2
UserForm3
UserForm4
UserForm5
UserForm6
UserForm7
UserForm8
UserForm9
Can you help?
macro below. (Imagine any number where the question mark is)
Sub ShowUserForm()
UserForm?.Show
End Sub
What I would like to do instead is have a macro that will call a different
random UserForm from this list below each time I activate it.
UserForm1
UserForm2
UserForm3
UserForm4
UserForm5
UserForm6
UserForm7
UserForm8
UserForm9
Can you help?