If you give your username list a name (named range) You colud use Data,
Validation, Allow, List and in the Source box type =YOUR NAMED RANGE.

HTH

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=547169