Combo/List Box and Check Box

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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 list shortcut 3
List or Combo Box Question 1
combo box - VBA form 3
Combo Box 1
Formatting Output Range in Combo Box 2
Combo box 2
Excel 2007 Combo Box questions 1
List box or Combo box?? 1

Back
Top