Validation - is a multi-column list possible?

Bill Vallance · Jun 8, 2004

I would like to have combo box functionality for the data validation feature
in Excel 2000. This doesn't seem to be available in the native validation
setup dialog box. Am I missing something? I would like to display the
validated items list in the leftmost column and have column(s) of
description display to the right of each list item (so I can tell which list
item I should select). Suggestions?

Many Thanks,

Bill Vallance

Gord Dibben · Jun 9, 2004

Bill

Debra Dalgleish has instructions for creating dependent DV lists.

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

Gord Dibben Excel MVP

Debra Dalgleish · Jun 9, 2004

There's a sample on my web site that mimics columns, using a macro.

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Data Validation "Columns" '

Bill Vallance · Jun 9, 2004

Thanks, both of you, for the quick response. Debra's "Columns" validation
solution will work perfectly for me.

Regards,

Bill Vallance