software

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: www.excelforum.com/member.php...oamp;userid=30450
View this thread: www.excelforum.com/showthread...hreadid=501120Hi

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

Andy.

quot;Conorquot; gt; wrote in
message ...
gt;
gt; All,
gt;
gt; This is for a single worksheet within a single workbook. The worksheet
gt; needs to have 2 dropdown boxes.
gt;
gt; I want users to select themselves from dropdown box #1.
gt;
gt; I want to populate the list of choices within dropdown box #2 based on
gt; who is signed in.
gt;
gt; I am sure VBA will be required, but probably not too daunting. I just
gt; can't get it. Thanks in advance.
gt;
gt; Conor
gt;
gt;
gt; --
gt; Conor
gt; ------------------------------------------------------------------------
gt; Conor's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30450
gt; View this thread: www.excelforum.com/showthread...hreadid=501120
gt;

I've only skimmed it so far, but it looks like this will do the job.
Thanks. You're the man.--
Conor
------------------------------------------------------------------------
Conor's Profile: www.excelforum.com/member.php...oamp;userid=30450
View this thread: www.excelforum.com/showthread...hreadid=501120