Drop Down List help

[tiffnh2002]

I have created a drop down list that has 6 options. I want to create a
second list based on their answer in the first list
example:
list 1: a,b,c,d,e,f
if a is picked in drop down 1 then drop down 2 will display
1,2,3,4,5,6,7,8,9,10
If b is picked then drop down 1 will display 11,12,13,14,15,16,

etc etc

 

[Jay Freedman]

I have created a drop down list that has 6 options. I want to create a
second list based on their answer in the first list
example:
list 1: a,b,c,d,e,f
if a is picked in drop down 1 then drop down 2 will display
1,2,3,4,5,6,7,8,9,10
If b is picked then drop down 1 will display 11,12,13,14,15,16,

etc etc

See http://gregmaxey.mvps.org/Linked_DropDown_Fields.htm

 

[Doug Robbins - Word MVP]

See the Cascading Listboxes section of the following
page on fellow MVP Greg Maxey's website:

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm



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