It sounds to me like you're creating your own Data|Filter|autofilter.

You may want to use the built-in tools that excel offers. It really makes life
easier.

wrote:

I have a an excel sheet with about 1000 rows of data, employee related
data, ID, Name, Department, Location...etc. I've gotten some help
here with a combobox and textboxes, which was great! Now I'd like to
expand on my user form by adding another combobox that will list the
Department IDs. When a given department is selected in the Combobox I
was thinking a listbox could be used to list all employees in that
department, with some of the particulars, like Full Time or Part time,
Hire Date...etc.

Can someone provide me with some sample code that might help me, a vba
newbie, a start?

--

Dave Peterson