Data Validation: Allow "List" or "Whole number"

[Guest]

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).

 

[tony h]

I don't think you can do it using data validation on one cell.

You could split it up into two parts or use somethink like the
selection_change event and code behind that.