Make a macro pause for user input

[Kathy Webster]

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

 

[Jay Freedman]

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.

 

[Kathy Webster]

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?

 

[Kathy Webster]

Never mind. I found an example through google. thanks for the
terminology to search for!
InputBox

 

[cyborgmaniac]

    Never mind. I found an example through google. thanks for the
terminology to search for!
InputBox







- Show quoted text -

What's the link, kathy?