View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_2_] Bob Phillips[_2_] is offline
external usenet poster
 
Posts: 5
Default 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?