2 Problems !! comboboxes and arrays

[Abo Rawad]

hi, all.

I have many columns in a sheet. let's say sheets("1stData"), which contains students data.

I have a 2 comboboxes cbStuClasses and cbStuNames

in the sheet, column (a) contains the students names. and column (b) contain the student classes.

as follow

Names class
stu1 1
stu2 1
stu3 1
stu4 2
stu5 2
stu6 3
stu7 3


and so on..


in combobox cbStuClasses i want the classes to be 1,2,3 .... and so on ( cbStuClasses.List =array(' the classes))

and whenever i choose the class number,
i want the students names in that class to be shown in cbStuNames. ( cbStuNames.rowsource = sheets("1stData").Range(rng).value ' Students names in the class chosen in cbStuClass)


That are the problems i am suffering from..

any help well be appreciated, and THANKs in advance.

[tigeravatar]

Abo Rawad,

I'm guessing these are on a userform. If that is the case, then these codes should work for you.
This is the UserForm_Initialize event that will populate a unique list of the classes:

Please Login or Register  to view this content.

When a class is chosen, the cbStuClasses_Change event is triggered, which can be used to populate the list of students with that class:

Please Login or Register  to view this content.

[Abo Rawad]

Man, you are a magician..

Thank you vary much....