populating a dropdown based on choice from a previous dropdown

C

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
 
G

Guest

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 said:
See http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top