Multiple combo boxes

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Lee (anonymous_at_discussions.microsoft.com)
Date: 05/06/04 

Date: Thu, 6 May 2004 02:43:33 -0700

I am currently producing a data sheet which used values
selected from 2 combo boxes to produce a given output.
The problem is that I would like to have the values of the
second combo box directly dependant on what value was
chosen from the first combo box.

For example cells A1 to A4 are for the first combo box and
by selecting from the first combo box 'A1' allows the
second combo box to display only the data from cells B1 to
B10, and again from the first combo box selecting 'A2' to
display only the data from cells C1 to C10.

Any ideas?

   Lee

Relevant Pages

  • Re: A Whole Slew of CheckBoxes
    ... Adjust the width of an appropriate column so that the cells are square. ... Adjust the shape of the rectangle so that it is very long and narrow. ... Make the rectangle invisible by selecting No Fill and No Line options ... You need only one rectangle to simulate any amout of check boxes. ...
    (microsoft.public.excel.programming)
  • Re: Looping Through Rows Question
    ... I read it too quickly and thought the OP was trying to "hurry things up" by selecting two smaller ranges rather than one bigger range. ... Leave the cells Item #4 selected as is and go into the VB ... Dim Firstrow As Long ... .Calculation = xlCalculationManual ...
    (microsoft.public.vb.general.discussion)
  • Re: Select All missing, Ctrl-A not working (Excel 2003 SP2)
    ... You can find a macro to make Ctrl+A work properly, ... means one thing in all applications where selecting everything ... data was entered as you entered it and the second Ctrl-A worked. ... I hit ctrl-a again and all the cells were selected. ...
    (microsoft.public.excel.setup)
  • Re: Control key
    ... Excel Product Group, 1998 - 2010 ... I can't select non adjacent cells using the control button ... For some reason I am having a terrible time selecting or highlighting a group ... Are you selecting say A1:A3 then hold CTRL key and select D1:D3? ...
    (microsoft.public.excel.newusers)
  • Re: Easiest way to insert multiple copied rows?
    ... The 'Insert Options' & 'Paste Options' buttons can be disabled in Excel> ... not the cells) to select as many rows as you want to insert, ... It's a real hassle to scroll all the way to the bottom just to ... "selecting N rows at your intended ...
    (microsoft.public.mac.office.excel)