Conditional Dropdowns on Steroids

[Bigfoot17]

I have been exploring the group on Conditional Dropdowns and have found some
valuable information and links. However, each example shows one dropdown
with content based on the content of another. I need to take this a step
further with a third dropdown dependent on the content of dropdown#2. Any
thoughts on how to do this? Here is an example:

Primary Secondary Tertiary

Fruits Apples Macintosh
Red Delicious
Pears Bartlett
Bosc
Anjou
Peaches Freestone
Clingstone
Veggies Greenbeans Stringless
French
Corn Sweet
Baby
Blue
Lettuce Iceberg
Romaine
Meat Beef Roasted
Marinated
Chicken Country-Fried
Jerked
Pork Pulled
Sliced

 

[Doug Robbins - Word MVP]

See the Cascading Listboxes section of
http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

The same technique can also be used for comboboxes

--
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, originally posted via msnews.microsoft.com