Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / August 2007

Tip: Looking for answers? Try searching our database.

Can I do this with VBA in Word?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RAO - 21 Aug 2007 12:54 GMT
-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!
Jonathan West - 21 Aug 2007 13:11 GMT
> -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

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

RAO - 21 Aug 2007 13:28 GMT
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?

> > -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
[quoted text clipped - 13 lines]
> How to create a Userform
> http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm
Jonathan West - 21 Aug 2007 13:38 GMT
> 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

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

RAO - 21 Aug 2007 13:52 GMT
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

> > Great,
> > thanks for the faster-than-the-speed-of-light reply!
[quoted text clipped - 8 lines]
>
> By all means post back here if you get stuck or have further questions
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.