Add a button to a sheet to open a userform
 

I'm looking for a way to add a button to a spreadsheet that will open up
a userform. I've seen it done before, I'm just not sure how do it.

Thanks,
Chris


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=380247

Hello Chris

Add a Command button to Excel double click it so it takes you to the vb
code & enter UserForm1.Show (between Private Sub CommandButton1_Click()
& End Sub)
& then click the add userform button (it's next to the save disk on the
tool bar).
& that's it.

Cheers Lee


--
robmeister
------------------------------------------------------------------------
robmeister's Profile: http://www.excelforum.com/member.php...o&userid=24364
View this thread: http://www.excelforum.com/showthread...hreadid=380247