Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello;
The value in cell C8 is picked-up from a dropdown list. The value in cell C9 is picked-up from a dropdown list based on the value selected in C8 (using a VBA custom Function to generate the list) The value in cell C10 is picked-up from a dropdown list based on the values selected in C8 and C9 (using a VBA custom Function to generate the list). The above data validation works fine and corresponds nicely to the desired systematic computations (say, SysComp). The question is: Is it possible to allow two (2) choices for the validation criteria in C9 and C10 ?? ... one for the above-described data validation (SysComp) and the other for "Whole number / between" (say, GenValue, for general values). Thank you kindly for your suggestion(s). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Data Validation: Allow "List" or "Whole number" | Excel Programming | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |