#1   Report Post  
Old December 21st 05, 10:40 PM posted to microsoft.public.excel.misc
Bob Barnes
 
Posts: n/a
Default 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



  #2   Report Post  
Old December 21st 05, 11:21 PM posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
  #3   Report Post  
Old December 21st 05, 11:24 PM posted to microsoft.public.excel.misc
Michael
 
Posts: n/a
Default 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


  #4   Report Post  
Old December 21st 05, 11:28 PM posted to microsoft.public.excel.misc
Bob Barnes
 
Posts: n/a
Default 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


  #5   Report Post  
Old December 21st 05, 11:29 PM posted to microsoft.public.excel.misc
Bob Barnes
 
Posts: n/a
Default 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



  #6   Report Post  
Old December 22nd 05, 12:29 AM posted to microsoft.public.excel.misc
Bob Barnes
 
Posts: n/a
Default 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

  #7   Report Post  
Old December 22nd 05, 04:06 PM posted to microsoft.public.excel.misc
Michael
 
Posts: n/a
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dropdown Lists Annabelle Excel Discussion (Misc queries) 5 December 28th 05 02:42 AM
Help Please with Dropdown lists and Vlookup TotallyConfused Excel Discussion (Misc queries) 2 December 1st 05 09:07 PM
continuing dropdown lists BLW Excel Worksheet Functions 1 May 16th 05 08:55 PM
Dropdown lists metrueblood Excel Discussion (Misc queries) 1 February 10th 05 12:17 AM
how do I add data validation dropdown lists to a Form SteveD.IFlora Excel Worksheet Functions 3 January 21st 05 04:48 PM


All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017