Create a button, right click on it and select Assign a macro, then
select new, you will then be taken to VBA and in the Button Click code
enter.

userform1.show

Go back to excel and click the Button, your UserForm will Show. (If it
is named UserForm1)

As far as the UserForm goes. You will have to create one first, then
come back to the forum and ask questions

Here's a good start

'Excel -- UserForms -- Create a UserForm'
(http://contextures.com/xlUserForm01.html)


--
Stringer
------------------------------------------------------------------------
Stringer's Profile: http://www.thecodecage.com/forumz/member.php?userid=117
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65801