This code loads the UserForm that the ComboBox resides on (I have also
created a
UserForm for each of the 4 other Employee Groups):

If Not Application.Intersect(Target, Range("C7:C1926")) Is Nothing Then
ReliefBoardHours.Show


And this is the RowSource for the ComboBox:

Employees


Emplyees is a defined name on the Employees worksheet.
"Patrick C. Simonds" wrote in message
...
This code loads the UserForm that the code resides on (I have also created
a UserForm for each of the 4 other Employee Groups):

If Not Application.Intersect(Target, Range("C7:C1926")) Is Nothing Then
ReliefBoardHours.Show


And this is the RowSource for the ComboBox:

Employees


Emplyees is a defined name on the Employees worksheet.


"Mike" wrote in message
...
What is your code to load the combobox ??

"Patrick C. Simonds" wrote:

I have a list of 200+ employees and they are divided between 5
workgroups. I
have a UserForm with a ComboBox which allows one to chose an employees
name.
The problem is now the requirement is that if I am working on a
worksheet
for one group, that only those people show in the ComboBox list of
employees. So I created an autofilter routine that compressed the list
of
employees depending on which worksheet was being worked on. The problem
is
that even after the autofilter routine runs, when the the UserForm is
shown
and you click on the drop down arrow for the ComboBox, all employees
still
show up. I was really hoping to not have to maintain multiple lists of
employees