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=501122

See http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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=501122

I downloaded the file given in this location and on opening this is OK

if I use the DV Example sheet and change the value in the first dropdown, it
gives me an error

Run time error '1004':
"Method 'Range' of object'_Worksheet' failed

Please help
Thanks
--
Baapi


"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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=501122