I am tryin to have 2 in-cell dropdown lists in an excel worksheet.
The list displayed in the 2nd dropdown is dependent on the value selected in the 1st one. Also, there should be the option for user input other than the listed items.
The first dropdown is working fine, and I have clumsily linked the second list to the 1st one by means of a macro triggered by a flag value stored in another cell. But Im sure there is another better way to do this either in Excel or VB. Can anyone help me? Thanks

*laughs* Actually, I just overcame a problem very similar to this. You'll be wanting to use a Database to accomplish this most like. At least it seems the most logical approach to me. Dropdown list 1 tells Dropdown list 2 what to access.

So If DDL1 was -

Fish
Dog
Cat

And DDL2 would list (if fish were chosen)

Salmon
Trout
Catfish

Then one way to do it is to have a database that has the Fields: Category listing 'Fish Dog Cat' as its records; Fish (Listing the fish choices); Dog (Listing the Dog Choices); and Cat (listing the Cat Choices)

If that makes any sense to you at all, I or someone else can explain/give the code to make it happen. (And if someone else has a better idea, I'm more than happy to learn :) )