Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Drop Down List

Hi

I'm zero in programming, I'm wondering if some one can provide me with the
code that create a drop down list for tables in a certain cell, then when
you select the name of the table, you get the required table. Any help will
be appreciated

Thanks


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default Drop Down List

Mr. Z

Data Validation with dependent list may serve for this function.

Have a look at Debra Dalgleish's site for info on the functionality of Data
Validation.

http://www.contextures.on.ca/xlDataVal02.html

Gord Dibben XL2002



On Tue, 2 Dec 2003 16:23:35 -0800, "Mr.Z" wrote:

Hi

I'm zero in programming, I'm wondering if some one can provide me with the
code that create a drop down list for tables in a certain cell, then when
you select the name of the table, you get the required table. Any help will
be appreciated

Thanks


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
drop down list based on other drop down list pick Ruth Excel Discussion (Misc queries) 1 August 25th 09 04:12 PM
Drop down list dependant on previous drop down list Tenacioushail Excel Discussion (Misc queries) 1 July 1st 08 11:35 AM
Drop down lists that auto create and then filter the next drop down list [email protected] Excel Worksheet Functions 2 September 30th 07 11:53 AM
Drop Down List choice selecting another drop down list CVD0722 Excel Worksheet Functions 3 October 31st 06 01:02 PM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM


All times are GMT +1. The time now is 05:35 AM.

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

About Us

"It's about Microsoft Excel"