VBA User Forms
 

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

VBA User Forms
 

Hi CJ,

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

HTH
Cheers
Carim

VBA User Forms
 

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

VBA User Forms
 

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