Dave - WORKS beautifully.
THANK you - Bob
"Dave Peterson" wrote:
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 wrote:
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