Can I use a UserForm Box with a Macro?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Vick
Could you e-mail me a copy of your sheet with some notes and i'll see what I
can do
(e-mail address removed)
 
Back
Top