MS Word drop downs

I

idrabefi

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

Doug Robbins

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.

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