|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Data Validation (Multiple Choice)
Take a look he
http://www.contextures.com/xlDataVal02.html
In article ,
John Jost wrote:
I am working on a spreadsheet that will contain data that will be loaded into
a database. As we will need to validate the information being entered, I am
planning on using the €śData, Validation€ť fields to load valid values.
However Im stumped. Based on the country selected from my country list, I
want to display one of two state lists (valid values). If USA is selected as
country I want to display the US state list. If Canada is selected, I want
to display the Canadian Province list. If any other country is selected I
want to allow the user to type any value.
Any suggestions
|