|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
can I define validation range by function?
Take a look he
http://www.contextures.com/xlDataVal02.html
In article ,
DPR wrote:
I'm trying to figure out a way to change the list that appears in a cell's
drop-down menu based on some IF statements. I have defined several different
named ranges that define my lists. Normally I would go to data validation
and enter the name there to form my drop down menu. In this case, though, I
want to make "rangeA" apply for my input value being less than 100, and
"rangeB" apply for when the value is greater than 100. Is there a way to do
this using data validation, or will I need to try a control drop-down with VB
coding?
|