[Groovingirl13]

I am looking to create a drop down menu.

So image in this... in cell C will be drop down menu that is related to the the value of what the drop down menu in cell A is. It may be an appliance such as a Dishwasher or whatever the particular appliance might be that is being inspected in an home. Then, when the appliance is selected in the cell A drop down, the options in the Drop down Menu in cell C will have the corresponding options that are related specifically to that particular appliance.

So basically if cell A = Dishwasher then the drop down menu in cell C should reference all the options that are Dishwasher related

And if Cell A = Water Heater then the drop Down Menu in cell C should reference all the options that are Water Heater Related

And….so on…

I have searched for a solution and nothing matches my scenario perfectly. Help!

[Mazzaropi]

Originally Posted by Groovingirl13

I am looking to create a drop down menu.

So image in this... in cell C will be drop down menu that is related to the the value of what the drop down menu in cell A is. It may be an appliance such as a Dishwasher or whatever the particular appliance might be that is being inspected in an home. Then, when the appliance is selected in the cell A drop down, the options in the Drop down Menu in cell C will have the corresponding options that are related specifically to that particular appliance.
So basically if cell A = Dishwasher then the drop down menu in cell C should reference all the options that are Dishwasher related
And if Cell A = Water Heater then the drop Down Menu in cell C should reference all the options that are Water Heater Related
And….so on…
I have searched for a solution and nothing matches my scenario perfectly. Help!

Hi Groovingirl13.

Take a look at these old posts where I solved a question like yours.

http://www.excelbanter.com/showpost....36&postcount=2

http://www.excelbanter.com/showpost....63&postcount=5

Tell if it worked for you.

Have a Nice day.

[GS[_2_]]

Here's a good place to start...

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

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

[Gord Dibben[_2_]]

Garry

You're too low-key<g

I would use "excellent" when describing Debra's site.

Gord

On Fri, 03 May 2013 20:38:20 -0400, GS wrote:

Here's a good place to start...

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

[CellShocked]

On Sat, 4 May 2013 01:17:58 +0100, Mazzaropi
wrote:


Groovingirl13;1611581 Wrote:
I am looking to create a drop down menu.

So image in this... in cell C will be drop down menu that is related to
the the value of what the drop down menu in cell A is. It may be an
appliance such as a Dishwasher or whatever the particular appliance
might be that is being inspected in an home. Then, when the appliance
is selected in the cell A drop down, the options in the Drop down Menu
in cell C will have the corresponding options that are related
specifically to that particular appliance.
So basically if cell A = Dishwasher then the drop down menu in cell C
should reference all the options that are Dishwasher related
And if Cell A = Water Heater then the drop Down Menu in cell C should
reference all the options that are Water Heater Related
And….so on…
I have searched for a solution and nothing matches my scenario
perfectly. Help!

Hi Groovingirl13.

Take a look at these old posts where I solved a question like yours.

http://www.excelbanter.com/showpost....36&postcount=2

http://www.excelbanter.com/showpost....63&postcount=5

Tell if it worked for you.

Have a Nice day.


Take a look at my tie sheet.

It has increments for the minutes, and the user chooses the increment
from a dropdown on the info page, and it changes the drop downs on the
time sheet.

[CellShocked]

On Fri, 03 May 2013 18:42:55 -0700, CellShocked
<cellshocked@thecellvalueattheendofthespreadsheet. org wrote:

On Sat, 4 May 2013 01:17:58 +0100, Mazzaropi
wrote:


Groovingirl13;1611581 Wrote:
I am looking to create a drop down menu.

So image in this... in cell C will be drop down menu that is related to
the the value of what the drop down menu in cell A is. It may be an
appliance such as a Dishwasher or whatever the particular appliance
might be that is being inspected in an home. Then, when the appliance
is selected in the cell A drop down, the options in the Drop down Menu
in cell C will have the corresponding options that are related
specifically to that particular appliance.
So basically if cell A = Dishwasher then the drop down menu in cell C
should reference all the options that are Dishwasher related
And if Cell A = Water Heater then the drop Down Menu in cell C should
reference all the options that are Water Heater Related
And….so on…
I have searched for a solution and nothing matches my scenario
perfectly. Help!

Hi Groovingirl13.

Take a look at these old posts where I solved a question like yours.

http://www.excelbanter.com/showpost....36&postcount=2

http://www.excelbanter.com/showpost....63&postcount=5

Tell if it worked for you.

Have a Nice day.


Take a look at my tie sheet.

It has increments for the minutes, and the user chooses the increment
from a dropdown on the info page, and it changes the drop downs on the
time sheet.


Oooops!


http://www.mediafire.com/view/?8atcc048a4dfndt

[GS[_2_]]

Garry

You're too low-key<g

I would use "excellent" when describing Debra's site.

Gord

On Fri, 03 May 2013 20:38:20 -0400, GS wrote:

Here's a good place to start...

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

Yep! You're absolutely right, Gord. I'll get it right next time...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion