Combobox Rowsource Dynamic Range

Hi Buddy,

I want to set the rowsource of combobox2 as dynamic range as follows:

range 1: if the value of combobox1 = "BD" then the combobox2 rowsource = a1:a10
range 2: if the value of combobox1 = "Drawing" then the combobx2 rowsource = b1:b10

Is this possible?

Roy Lam