Conditioned Drop Down Options?

[hedbeb]

Does anyone know if it's possible to build logic into a drop-down list that
says: based on what chosen in "drop-down list #1" it manipulates what's
available to choose in "drop-down list #2"? Specifically, I want to have 3
drop-down lists and as you make your selection in the first two, it narrows
the available choices in the 3rd drop-down list.

If anyone has done something like this please let me know.

 

[Jay Freedman]

Does anyone know if it's possible to build logic into a drop-down
list that says: based on what chosen in "drop-down list #1" it
manipulates what's available to choose in "drop-down list #2"?
Specifically, I want to have 3 drop-down lists and as you make your
selection in the first two, it narrows the available choices in the
3rd drop-down list.

If anyone has done something like this please let me know.

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

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[hedbeb]

Thanks Jay, this helped with the initial question but when creating a
UserForm ListBox and the associated macro, what does Me.ListBox1.Clear
mean? It keeps rejecting the on the word "Me"?

 

[Jay Freedman]

The word "Me" refers to the userform itself, and the fact that you're getting an
error there makes me think you may have put Greg's code into a regular macro
module, instead of putting it in the code window of the userform. Only the
three-line macro CallFillStateDD should be in a regular module.

For reference, the expression Me.ListBox1.Clear removes any items that are
already in the listbox, in preparation for filling it with other state
abbreviations.