Import Outlook group contacts into Excel VBA ComboBox?

Hi all,

I have made a userform for my company to use, but I need to add a ComboBox in it which lets you select your name.

Now I have already made one using simple .AddItem commands, but since the company is growing a lot the code would require a lot of maintenance.
So what I need to do is find out how to take the names from a certain 'group' in the address book of the companies global address list, so that every time we have a new hire and it's name is added into the group on the email the persons name would automatically appear in the drop down list.

Any ideas?

Some clarification.

http://i.imgur.com/1wfYSYZ.jpg

Please Login or Register  to view this content.

This is the code I am trying to tweek, but it gives no compiling errors at all. Simply nothing happens.