Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
sot sot is offline
external usenet poster
 
Posts: 19
Default Combo/List Box and Check Box

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo/List Boxes shercala Excel Worksheet Functions 0 December 6th 06 02:35 PM
Combo box or list box famdamly Excel Discussion (Misc queries) 2 January 11th 06 03:58 AM
Combo Box List aftamath Excel Discussion (Misc queries) 2 October 5th 05 09:39 PM
Combo box list question tanner g Excel Discussion (Misc queries) 1 April 21st 05 09:59 AM
Combo box list depends on value Neal Excel Discussion (Misc queries) 3 February 1st 05 09:52 PM


All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"