Prev: drop down form field and VBA
Next: Modify maco - extract definition 1st then acronym within ( )
From: Bigfoot17 on 13 Apr 2010 15:08
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
From: Doug Robbins - Word MVP on 13 Apr 2010 17:34
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

"Bigfoot17" <Bigfoot17(a)discussions.microsoft.com> wrote in message
news:9611453B-3C71-442A-86E6-8CEC3AE5358C(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: drop down form field and VBA
Next: Modify maco - extract definition 1st then acronym within ( )