View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
monir monir is offline
external usenet poster
 
Posts: 215
Default Data Validation: Allow "List" or "Whole number"

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