UserForms - Building a document generator - I need some foundation!!!!

[Daynger]

Okay, so this is probably extremely tedious for you folks, but I need
some help! I'm trying to build a Quote/Proposal Template in Word that
pulls data from an excel spreadsheet and places it in specific
locations... I'm assuming "Bookmarked" locations. I'd like to create a
UserForm, or Custom Dialog Box, that requires the user to select
specific criteria - each selection will determine the available choices
for the next selection. Ironically I work for a technology firm --->
doing sales and I need a more proficient way to build my documents. So,
when I open my template, I'll have a choice of product category - from
there I'll only have the option to select items that pertain to that
category. From what I understand, that will done using listboxes and
comboboxes that pull the external data...
Other than that, is it possible to pull the data directly from a
website?

Help is much appreciated!!!!

 

[Doug Robbins - Word MVP]

See the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

In the posts in the following link, you will find a routine that I created
for some one else that populates a second combobox with data pertaining to
the item selected in another combobox. In this case, the data for the
comboboxes is stored in a two column table in a Word document, one item to a
row in the case of of the first combobox and the items pertaining to each
item as separate paragraphs in the adjacent cell in the second column.


http://groups.google.com/group/micr...e2c34e?q=Doug+Robbins&rnum=7#bf86a5657fe2c34e

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Daynger]

This definitely gives me a good start. Thanks for your help!