balajin
04-10-2010, 10:15 PM
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:
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: