Dropdown Lists...
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 |
Dropdown Lists...
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 |
Dropdown Lists...
Good afternoon, Bob. You might find something you can use on the following
site: http://www.xldynamic.com/source/xld.Dropdowns.html. HTH -- Sincerely, Michael Colvin "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 |
Dropdown Lists...
Michael - Thank you - clicking the site below has a "page not found".
"Michael" wrote: Good afternoon, Bob. You might find something you can use on the following site: http://www.xldynamic.com/source/xld.Dropdowns.html. HTH -- Sincerely, Michael Colvin "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 |
Dropdown Lists...
Dave - Thank you - I'll try it & Post my result.
"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 |
Dropdown Lists...
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 |
Dropdown Lists...
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. -- Sincerely, Michael Colvin "Bob Barnes" wrote: Michael - Thank you - clicking the site below has a "page not found". "Michael" wrote: Good afternoon, Bob. You might find something you can use on the following site: http://www.xldynamic.com/source/xld.Dropdowns.html. HTH -- Sincerely, Michael Colvin "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 |
All times are GMT +1. The time now is 08:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com