Combo/List Box and Check Box

G

Guest

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?
 
B

Bob Phillips

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box - VBA form 3
Combo Box Help 3
List or Combo Box Question 1
List box or Combo box?? 1
Appearance of Data Validation Combo Box 2
Formatting Output Range in Combo Box 2
Combo box 2
Link cell to combo box 2

Top