ComboBox to Populate ListBox

Good Morning all, I hope someone can help me with this simply VB query. I have searched the forums but cannot seem to find the answer.

I have attached a sheet (not much on it as the live version I cannot attach as it is on a different system) in which I need the ListBox to display the cells that are under the heading when selected in the ComboBox. An example would be that if Server-1 was selected in the ComboBox it would show in ListBox under permissions the relevant groups. Additionally I would like it to show in the Management group, which Management group contained the Server Group.

Hope this makes sense. The only real constraint is that it needs to run on Excel 2003.

Server.xls

Hi Jamie, c da nclsd sheet, hope u dis resolves u r problem.

Originally Posted by navn

Hi Jamie, c da nclsd sheet, hope u dis resolves u r problem.

Navn, that does help a little bit. But on my original sheet I had management groups which I also wanted to be displayed in a list box. A server group would be a member of a management group.

Originally Posted by Jamie0691

Navn, that does help a little bit. But on my original sheet I had management groups which I also wanted to be displayed in a list box. A server group would be a member of a management group.

Jamie, can you please fill the data complete on ServerList sheet, so that i can better understand what u mean by management group.

Originally Posted by navn

Jamie, can you please fill the data complete on ServerList sheet, so that i can better understand what u mean by management group.

Navn, apologies for the delay. Please see attached the updated sheet. Basically this is the scenario.

A server will have groups to define permissions as to what can be done. A user will logon with a managment account which has some, but not all of these groups nested. I need to have a way of a user picking either a server or management group and this displaying what rights they have or what is required. I have updated the spreadsheet to reflect this.

Thanks for all the help!Server (Updated).xlsm