I've got a userform with mutliple combo boxes

Each of the combo boxes selects from a separate named range

Is it possible to have the options in combo box 2 change depending on the option selected in combo box 1?

eg

combo box 1 choices, 1,2,3,4,5 (named range 1)
combo box 2..........
if combo box is "1" then select from (named range 2) a,b,c,d,
if combo box is "2" then select from (named range 3) X,y,z

then if combo box 2 is X then select from (named range 4) P, Q,R)

I've used combo boxes in my form but there may be an easier way. I am willing to learn.

Thanks in advance.