excel VBA Code for dependent combobox

hello,

i have created the attached userform and i need to do some fine tuning to make it as streamlined as possible.

Here is what i need it to do:

when manager name Martin is selected i need the team box to show "northern"
when manager name Ian is selected i need the team box to show "northern"
when manager name Gavin is selected i need the team box to show "southern"
when manager name Christine is selected i need the team box to show "southern"
when manager name Delma is selected i need the team box to show "central"
when manager name colette is selected i need the team box to show "central"

at the moment they need to select the corect team from the drop down list.

I also would like it that when the user selects "Gold target" the drop down list for branch name is populated with the list on "sheet 3". at the moment this list is empty because i cant share that information. eventually there will be lots of lists on "sheet 3" for the other partners but if i could get code for one of them i can do the rest.

your help is greatly appreciated.

thanks

MattDistributions 2012 SG.xlsm

Hi Matt
I've added this code to your workbook (along with several Named Ranges)

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

I'm only guessing what you want here

I also would like it that when the user selects "Gold target" the drop down list for branch name is populated with the list on "sheet 3". at the moment this list is empty because i cant share that information. eventually there will be lots of lists on "sheet 3" for the other partners but if i could get code for one of them i can do the rest.

Let me know of issues.

Hi Matt
You're welcome...glad I could be of help.