Combo/List Box and Check Box
With Data Validation you could use a List type with a formula of say
=IF(A1="Colour",rngColour,rngNoColour)
where A12 hold the word Colour or not, and rngColour is a named range of the
colour prointers, rngNoColour a named range of the B&W.
HTH
Bob
"sot" wrote in message
...
Is it possible to have a list or combo box deliver a specific list if a
checkbox is selected. i.e if the colourprinter checkbox is selected, the
list/combo box displays the colourprinter list? I would rather have a
solution that did not involve VBA as I don't feel confident enough.
Perhaps
its possible with Data Validation or by using the forms toolbar?
|