Add a button to a sheet to open a userform

P

PokerZan

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
 
R

robmeister

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
 
Top