Trying to see if anyone has created a macro/form that enables a user to
select an item from a drop down list that will then populate the rest
of the form based on that selection.

Here's an example: Say you're buying a new car and you'd like to be
able to select all of the options associated with a particular model.
If you selected Model A from a drop down list then the rest of the
worksheet would be populated with options relating to that model.
Likewise, if you selected Model B from the drop down list other
information would be populated.

I'm stumped. Any help would be appreciated.

This sounds like a job for the VLOOKUP function..........check it out, and
if you need more specific help, post back.

Vaya con Dios,
Chuck, CABGx3


"Excell" wrote in message
oups.com...
Trying to see if anyone has created a macro/form that enables a user to
select an item from a drop down list that will then populate the rest
of the form based on that selection.

Here's an example: Say you're buying a new car and you'd like to be
able to select all of the options associated with a particular model.
If you selected Model A from a drop down list then the rest of the
worksheet would be populated with options relating to that model.
Likewise, if you selected Model B from the drop down list other
information would be populated.

I'm stumped. Any help would be appreciated.

Check out Debra Dalgliesh's site on dependent data validation lists

http://www.contextures.com/xlDataVal02.html


"Excell" wrote:

Trying to see if anyone has created a macro/form that enables a user to
select an item from a drop down list that will then populate the rest
of the form based on that selection.

Here's an example: Say you're buying a new car and you'd like to be
able to select all of the options associated with a particular model.
If you selected Model A from a drop down list then the rest of the
worksheet would be populated with options relating to that model.
Likewise, if you selected Model B from the drop down list other
information would be populated.

I'm stumped. Any help would be appreciated.