Dropdown Lists...

[Bob Barnes]

I'm an Access Developer.

I looked at a sample Excel file where you select a country, & then the
adjacent dropdown shows the cities entered for that country.

I pasted the code, & tried modifying it, but I keep getting a "link" telling
me I can't change it when I try Data Validation.

Any tips to get this to work?

TIA - Bob

 

[Dave Peterson]

I'd use some of the tips at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal02.html

And use Data|Validation for both cells.

 

[Michael]

Good afternoon, Bob. You might find something you can use on the following
site: http://www.xldynamic.com/source/xld.Dropdowns.html. HTH

 

[Bob Barnes]

Michael - Thank you - clicking the site below has a "page not found".

 

[Bob Barnes]

Dave - Thank you - I'll try it & Post my result.

I'd use some of the tips at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal02.html

And use Data|Validation for both cells.

 

[Bob Barnes]

Dave - WORKS beautifully.

THANK you - Bob

I'd use some of the tips at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal02.html

And use Data|Validation for both cells.

 

[Michael]

Hi Bob. Sorry about that. I just tried it again by putting it into a cell
on an Excel spreadsheet, hitting F2 and Enter, and it worked for me. Here's
one more try: http://www.xldynamic.com/source/xld.Dropdowns.html. Hope it
works this time.