Can I use a UserForm Box with a Macro?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vick - 17 May 2007 20:53 GMT

I want to take the data from my textboxes (Subject, Body) and use them in my
macro. So at the begining I want the Macro to open the userform, and if they
click Ok, then the macro continues. It fills takes the text that the user
typed in from text box and places it in Text area of my macro. If they hit
cancel the macro ends. Any ideas?

Thanks

Reply to this Message

Mike - 17 May 2007 22:03 GMT

When you say at the begging does this mean when you open the file

> I want to take the data from my textboxes (Subject, Body) and use them in my
> macro. So at the begining I want the Macro to open the userform, and if they
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

Vick - 17 May 2007 22:11 GMT

I meant at the begining of the macro, when they press the button to kick off
the macro the Userform will pop up and go from there.

> When you say at the begging does this mean when you open the file
>
[quoted text clipped - 5 lines]
> >
> > Thanks

Reply to this Message

Mike - 18 May 2007 01:32 GMT

Vick
Could you e-mail me a copy of your sheet with some notes and i'll see what I
can do
mjones@troinc.com

> I meant at the begining of the macro, when they press the button to kick off
> the macro the Userform will pop up and go from there.
[quoted text clipped - 8 lines]
> > >
> > > Thanks

Reply to this Message