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.


--
Obi-Wan Kenobi
------------------------------------------------------------------------
Obi-Wan Kenobi's Profile: http://www.excelforum.com/member.php...o&userid=32578
View this thread: http://www.excelforum.com/showthread...hreadid=525807

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.


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=525807