dynamic combo box in a userform

[jiries1985]

hi there,

im still new but i learned a bunch of tricks on vba that help a lot. now i have a problem as follow,

i have 11 pre-named ranges on sheet1,
first one have classes and its name is "expclass"
and it contains 10 items ( class1, class2, class3, to class10)
and the other 10 pre-named ranges is a list for each class.
now i have a user form with two comboboxes 1& 2
first one "combobox1 " rowsource is expclass so it shows class1,2,3,4....
now i need the second combobox to change its list according to the value of combo box 1

p.s all the ranges are prenamed