Add a button to a sheet to open a userform

[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

[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