Cindy,

If the command button is from the Forms toolbar, assign the
following macro to the button.

Sub ShowTheForm()
UserForm1.Show
End Sub

If the command button is from the Controls toolbar, put the
following code in the button's Click event procedu

UserForm1.Show


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Cindy Kester" wrote in message
...
Thank you. I was working on that idea before your reply but
how do you
open the user form from a command button on the worksheet?



Cindy

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!