Add RowSource to Userform ComboBox based on value on Another ComboBox

Hi,

Exactly as it says in the title. Can I add the RowSource of a ComboBox based on the Value of another ComboBox.

Example

Me.ComboBox2.RowSource = Me.ComboBox1.Value

This doesn't work but does anyone have any idea what might.

Thanks in Advance