Combobox enquiry

[gmazza76]

Good Evening,

I have 3 combobox's on a userform that i need to give specific Information.

I have ComboBox1 That lets you select 1 of 6 managers.
I want ComboBox2 to restrict ( make visible ) information that is relevant to the managers name in combobox1

The information is setup on a seperate sheet in the workbook "Info"
Column A = Managers Name
Column B = Agent Names

Is there anyway i can have this done on a userform???


Many Thanks
Gavin