Hi

Have a look he
http://www.contextures.com/xlDataVal02.html

Andy.

"Conor" wrote in
message ...

All,

This is for a single worksheet within a single workbook. The worksheet
needs to have 2 dropdown boxes.

I want users to select themselves from dropdown box #1.

I want to populate the list of choices within dropdown box #2 based on
who is signed in.

I am sure VBA will be required, but probably not too daunting. I just
can't get it. Thanks in advance.

Conor


--
Conor
------------------------------------------------------------------------
Conor's Profile:
http://www.excelforum.com/member.php...o&userid=30450
View this thread: http://www.excelforum.com/showthread...hreadid=501120