userform with looping code

Still haven't fired up the 2003 m/c however give this a try.

I have dropped the string lists from the data validation and substituted dynamic named ranges for available employees.
This is backed up with code to keep the lists clean.

You should now manage to use commas in their names.
We might have problems with employees that have the same name. For now at least try to give them unique names, e.g. R. Smith, Rob Smith, Robert Smith, Bob Smith, R. J. Smith... etc.
Long term it would be better to use their works number and don't reuse that number again when someone leaves.

We'll get there soon....