|
|
|
date: Wed, 2 Apr 2008 17:07:55 -0700,
group: microsoft.public.word.vba.beginners
back
Re: Make a macro pause for user input
On Wed, 2 Apr 2008 17:07:55 -0700, "Kathy Webster" wrote:
>How can I make a macro pause for the user to type some text that I will plug
>in to multiple places during the course of the macro?
>
>TIA,
>Kathy
>
Although you _can_ use the InputBox statement to pop up a box to ask for input,
there are usually better ways.
For example, if there will be many such popups (say, more than three), that can
get very annoying for users. It's usually better to program a Userform
(http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm) to get all the
information at once.
If you're just accepting input and placing it at various spots in the document,
you may not need a macro at all. Read
http://gregmaxey.mvps.org/Repeating_Data.htm for various ways to use fields for
this.
--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
date: Wed, 02 Apr 2008 21:06:35 -0400
author: Jay Freedman
Re: Make a macro pause for user input
I am aware of the FORM solutions, and I use them quite a bit. In this
instance, however, I am finding that a macro is the best tool.
Can you show me an example of how I would use the InputBox statement or
another technique to have their response fill into multiple places?
"Jay Freedman" wrote in message
news:14b8v3h3uac7ddgfcllltavk18m2dn06ng@4ax.com...
> On Wed, 2 Apr 2008 17:07:55 -0700, "Kathy Webster"
> wrote:
>
>>How can I make a macro pause for the user to type some text that I will
>>plug
>>in to multiple places during the course of the macro?
>>
>>TIA,
>>Kathy
>>
>
> Although you _can_ use the InputBox statement to pop up a box to ask for
> input,
> there are usually better ways.
>
> For example, if there will be many such popups (say, more than three),
> that can
> get very annoying for users. It's usually better to program a Userform
> (http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm) to get all
> the
> information at once.
>
> If you're just accepting input and placing it at various spots in the
> document,
> you may not need a macro at all. Read
> http://gregmaxey.mvps.org/Repeating_Data.htm for various ways to use
> fields for
> this.
>
> --
> Regards,
> Jay Freedman
> Microsoft Word MVP FAQ: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup
> so all may benefit.
date: Wed, 2 Apr 2008 21:43:54 -0700
author: Kathy Webster
Re: Make a macro pause for user input
Never mind. I found an example through google. thanks for the
terminology to search for!
InputBox
"Kathy Webster" wrote in message
news:47f460a4$0$11328$4c368faf@roadrunner.com...
>I am aware of the FORM solutions, and I use them quite a bit. In this
>instance, however, I am finding that a macro is the best tool.
> Can you show me an example of how I would use the InputBox statement or
> another technique to have their response fill into multiple places?
>
> "Jay Freedman" wrote in message
> news:14b8v3h3uac7ddgfcllltavk18m2dn06ng@4ax.com...
>> On Wed, 2 Apr 2008 17:07:55 -0700, "Kathy Webster"
>> wrote:
>>
>>>How can I make a macro pause for the user to type some text that I will
>>>plug
>>>in to multiple places during the course of the macro?
>>>
>>>TIA,
>>>Kathy
>>>
>>
>> Although you _can_ use the InputBox statement to pop up a box to ask for
>> input,
>> there are usually better ways.
>>
>> For example, if there will be many such popups (say, more than three),
>> that can
>> get very annoying for users. It's usually better to program a Userform
>> (http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm) to get all
>> the
>> information at once.
>>
>> If you're just accepting input and placing it at various spots in the
>> document,
>> you may not need a macro at all. Read
>> http://gregmaxey.mvps.org/Repeating_Data.htm for various ways to use
>> fields for
>> this.
>>
>> --
>> Regards,
>> Jay Freedman
>> Microsoft Word MVP FAQ: http://word.mvps.org
>> Email cannot be acknowledged; please post all follow-ups to the newsgroup
>> so all may benefit.
>
>
date: Wed, 2 Apr 2008 21:53:45 -0700
author: Kathy Webster
Re: Make a macro pause for user input
On Apr 3, 12:53 am, "Kathy Webster" wrote:
> Never mind. I found an example through google. thanks for the
> terminology to search for!
> InputBox
>
> "Kathy Webster" wrote in message
>
> news:47f460a4$0$11328$4c368faf@roadrunner.com...
>
>
>
> >I am aware of the FORM solutions, and I use them quite a bit. In this
> >instance, however, I am finding that a macro is the best tool.
> > Can you show me an example of how I would use the InputBox statement or
> > another technique to have their response fill into multiple places?
>
> > "Jay Freedman" wrote in message
> >news:14b8v3h3uac7ddgfcllltavk18m2dn06ng@4ax.com...
> >> On Wed, 2 Apr 2008 17:07:55 -0700, "Kathy Webster" >> wrote:
>
> >>>How can I make a macro pause for the user to type some text that I will> >>>plug
> >>>in to multiple places during the course of the macro?
>
> >>>TIA,
> >>>Kathy
>
> >> Although you _can_ use the InputBox statement to pop up a box to ask for
> >> input,
> >> there are usually better ways.
>
> >> For example, if there will be many such popups (say, more than three),
> >> that can
> >> get very annoying for users. It's usually better to program a Userform
> >> (http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm) to get all
> >> the
> >> information at once.
>
> >> If you're just accepting input and placing it at various spots in the
> >> document,
> >> you may not need a macro at all. Read
> >>http://gregmaxey.mvps.org/Repeating_Data.htmfor various ways to use
> >> fields for
> >> this.
>
> >> --
> >> Regards,
> >> Jay Freedman
> >> Microsoft Word MVP FAQ:http://word.mvps.org
> >> Email cannot be acknowledged; please post all follow-ups to the newsgroup
> >> so all may benefit.- Hide quoted text -
>
> - Show quoted text -
What's the link, kathy?
date: Thu, 17 Apr 2008 12:04:10 -0700 (PDT)
author: unknown
|
|
