Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I use a UserForm Box with a Macro?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I use a UserForm Box with a Macro?
When you say at the begging does this mean when you open the file
"Vick" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I use a UserForm Box with a Macro?
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. "Mike" wrote: When you say at the begging does this mean when you open the file "Vick" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I use a UserForm Box with a Macro?
Vick
Could you e-mail me a copy of your sheet with some notes and i'll see what I can do "Vick" wrote: 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. "Mike" wrote: When you say at the begging does this mean when you open the file "Vick" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to call-up UserForm | Excel Worksheet Functions | |||
Userform/macro help | Excel Discussion (Misc queries) | |||
Userform Macro | Excel Discussion (Misc queries) | |||
how to run macro in userform button | Excel Discussion (Misc queries) | |||
How can I run a macro in the background whilst a UserForm is visib | Excel Discussion (Misc queries) |