I hope this is the right place to post this question. I feel very dumb
asking this. I have created a user form and it works fine, but I do
not know how to activate it in the workbook. I have searched
everywhere but I cannot figure this out. How do I add something to a
menu to use my user form? Thanks for any replies.


--
CJ-22
------------------------------------------------------------------------
CJ-22's Profile: http://www.excelforum.com/member.php...o&userid=17551
View this thread: http://www.excelforum.com/showthread...hreadid=519442

Hi CJ,

the name of your form followed by a period and the instruction Show ...
e.g.
Input.Show

HTH
Cheers
Carim

Sub ShowForm()
Userform1.Show
End Sub

attach that macro to your button like you would any other macro.

--
Regards,
Tom Ogilvy


"CJ-22" wrote in
message ...

I hope this is the right place to post this question. I feel very dumb
asking this. I have created a user form and it works fine, but I do
not know how to activate it in the workbook. I have searched
everywhere but I cannot figure this out. How do I add something to a
menu to use my user form? Thanks for any replies.


--
CJ-22
------------------------------------------------------------------------
CJ-22's Profile:
http://www.excelforum.com/member.php...o&userid=17551
View this thread: http://www.excelforum.com/showthread...hreadid=519442

Thanks Carim and Tom. This works great. I didn't even think of
creating a macro to show the userform. Thanks again.


--
CJ-22
------------------------------------------------------------------------
CJ-22's Profile: http://www.excelforum.com/member.php...o&userid=17551
View this thread: http://www.excelforum.com/showthread...hreadid=519442