MS Word drop downs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

idrabefi - 12 Apr 2005 15:56 GMT

I am not vb programmer. Can anyone help define method to associate 2 drop
down list boxes?

As example, suppose first drop down is Area (i.e., work area (Procurement,
Finance, Logistics, etc.)). Second drop down is Title (i.e., job title
(clerk, manager, director, etc.)). Title list of values is dependent upon
Area (i.e., noted titles only pertain to Procurement Area).

Thanks in advance for any help you can provide.

Reply to this Message

Doug Robbins - 22 Apr 2005 15:37 GMT

Store the data in a two column table in a Word document with each Area
occuping a cell in the first column and the titles associated with each area
being in separate paragraphs in the corresponding cell in the second column.
Now load the Area listbox by iterating through the cells of the first column
and one exit from the Area listbox, use its .Index property to determine the
row of the table that corresponds to the Area that has been selected and
then load the second list box by iterating through the paragraphs in the
corresponding cell in the second column.

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

>I am not vb programmer. Can anyone help define method to associate 2 drop
> down list boxes?
[quoted text clipped - 5 lines]
>
> Thanks in advance for any help you can provide.

Reply to this Message