hi Gary

essentially, this workbook will be used by quite a large number of
employees in our department. this will trace a workflow from level 1 to
4. each level has limited access.
i am sure there might be a more efficient way of doing this but this is
how i envisioned it to work. also the comboboxes allow for limited user
interference.

Well I still don't see the point of the comboboxes by your explanation.
My point is that if they don't serve any other purpose then why not
just put the filtered lists directly into the target sheet. You can do
this with a simple button control (or menuitem)! What else does the
userform get used for? If only to serve as a vehicle to make the lists
then it makes no sense to me!

--
Garry

Free uenet access at http://www.eternal-september.org
Classic VB Users Regroup
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion