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