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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daynger - 10 Nov 2005 13:20 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 10 Nov 2005 19:40 GMT

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/microsoft.public.word.vba.userforms/browse_thread
/thread/f3f67faa8297aa66/bf86a5657fe2c34e?q=Doug+Robbins&rnum=7#bf86a5657fe2c34e

Signature

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

> 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
[quoted text clipped - 12 lines]
>
> Help is much appreciated!!!!

Reply to this Message

Daynger - 11 Nov 2005 13:01 GMT

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

Reply to this Message