User Form

O

Obi-Wan Kenobi

Can anyone advise how I would activate a user form by pressing a button
on a work sheet?

I have created a simple user form but don’t know how to get it to open.
I’m quite new to macros. I can build simple macros but I am not to sure
how to do this.:mad:
 
K

keithl816

Right click your command button, click on view code and place


Code:
--------------------
UserForm1.Show
--------------------


Between Private Sub CommandButton1_Click() and End Sub

Change your userform number to whatever number it is, same with the
command button number, also make sure to exit design mode.
 
Top