offer dropdown options based on another dropdown

[Conor]

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

 

[Guest]

Hi

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

Andy.

 

[Conor]

I've only skimmed it so far, but it looks like this will do the job.
Thanks. You're the man.