Templates and data input

[RAO83]

-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.

If yes, could you give me a hint as to how?


Cheers in advance



RAO

[lucas]

How about a userform that uses bookmarks in the formatted template? See attached.

[RAO83]

great thanks!!

[lucas]

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.

I would suggest a combobox on the userform for this problem

[lucas]

Try to use descriptive titles to your threads. It will help your responses and it will be easier for others to search later. Help or can I do this is not very descriptive. I changed the title of your thread.

[mdmackillop]

Userform sample (http://vbaexpress.com/kb/getarticle.php?kb_id=184)