Can I do this with VBA in Word?

R

RAO

-Create a set of inputboxes that ask for user input in a step by step
fashion, and eventually write everything to a predefined and formatted
Word-template file.

-get some of the inputboxes to generate a predefined list of inputchoices
(in a pull down menu or via autotext) to speed-up the typing.

Cheers in advance!
 
J

Jonathan West

RAO said:
-Create a set of inputboxes that ask for user input in a step by step
fashion, and eventually write everything to a predefined and formatted
Word-template file.

Yes. You can use the InputBox function for this
-get some of the inputboxes to generate a predefined list of inputchoices
(in a pull down menu or via autotext) to speed-up the typing.

The InputBox can't give you a dropdown list of predefined choices, but a
UserForm can - and you can have all your input items as separate fields on
the same UserForm.

Take a look here for a starting point.

How to create a Userform
http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm
 
R

RAO

Great,
thanks for the faster-than-the-speed-of-light reply!

So in short, for my task I should rather use Userforms than write a new macro
to generate inputboxes?
 
J

Jonathan West

RAO said:
Great,
thanks for the faster-than-the-speed-of-light reply!

So in short, for my task I should rather use Userforms than write a new
macro
to generate inputboxes?

Yes. You can have a single UserForm with multiple textboxes and dropdown
listboxes. The article I pointed you to will show you much of what you need
to do. You will of course need to adapt it to your own purposes.

By all means post back here if you get stuck or have further questions
 
R

RAO

Thanks alot Jonathan,

you're helping me out a great deal
and saving me lots of time on project
here.

Your help is much appreciated.

Big cheers!

Rao
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top