ExcelBanter - Drop Down List

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Drop Down List (https://www.excelbanter.com/excel-programming/284207-drop-down-list.html)

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

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