VBA User Forms

[CJ-22]

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.

[Carim]

Hi CJ,

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

HTH
Cheers
Carim

[Tom Ogilvy]

Sub ShowForm()
Userform1.Show
End Sub

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

--
Regards,
Tom Ogilvy


"CJ-22" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[CJ-22]

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