Sleeper: Get Combobox2 value if a value is selected in combobox1 in the WorkSheet

[balajin]

Hi,

I have a doubt in excel combobox, i am using combobox in sheet.

i created two combobox in sheet1 and i entered the data in cells and get in combobox1,

for example, in sheet1:
A1 - Name
A2 - Subject
A3 - Class

I get these details in combobox1 by giving the cell range (A1:A3) in combobox1 properties.

If i select Name in combobox1, i want the only name list in the combobox2 or if i select the subject in combobox1, the combobox2 will display only the subject details.

B1 - John
B2 - David

and

C1 - Maths
C2 - English

How could i get these details in combobox2.

Thank you,
Bala N :hi:

[Aussiebear]

Have a look here, http://www.contextures.com/excelfiles.html

Debra, in her wonderful website has a working method which should be of some assistance.