Drop Down List ActiveX

**yching** · 04-26-2013, 12:34 AM

hey,

Could anyone help me out with this?

I have the following data:

Alphabets (in Sheet1)
A Type Points
A1-------1
A1-------2
A1-------3

B Type Points
B2-------1
B2-------2
B2-------3
B2-------4

In Sheet2, I would like to have a drop down list (i named it as Type) that has a different types of alphabets, which I have already done so. I cant figure out how my second drop down list (i named it as Point) will it work if i were to select different types of alphabets. For example, when i select A1 from Type list, i will like my Point list for A1 to have points from 1-3 (not 1 -4).

obviously, i can make my Points list to have numbers from 1-4 for these 2 types of alphabets. However, A1 has only 3 points. So i only want my Points list to appear from 1-3 when i have selected A1; and points 1-4 when i have selected B2.

Sorry if i confuse anyone as im not good at explaining things. basically, thats what i hope to do for my excel sheet2.

any advice will be very appreciated. thanks.

**Cheeky Charlie** · 04-26-2013, 06:14 AM

Hi, try googling 'dependent validation lists'. Normal examples assume you will have A list, B list, etc. in consecutive columns, although this can be addressed.
Let us know if that helps or you get stuck.

Sorry, I note from the title you're using ActiveX drop-downs. The same logic as outlined in dependent validation lists can easily be used to set the rowsource for an activex combobox or listbox based on entry/selection in other controls or the sheet itself.

**Cheeky Charlie** · 04-26-2013, 06:16 AM

Hi, try googling 'dependent validation lists'. Normal examples assume you will have A list, B list, etc. in consecutive columns, although this can be addressed.
Let us know if that helps or you get stuck.

Sorry, I note from the title you're using ActiveX drop-downs. The same logic as outlined in dependent validation lists can easily be used to set the rowsource for an activex combobox or listbox based on entry/selection in other controls or the sheet itself.