Combo Boxs

rama1712

New Member
Joined
Jun 19, 2003
Messages
6
I have been asked to try and do this for a pupil.

1) They Select and option from Combo Box1 this in turn changes what is avail in Combo Box 2

IE Select memeber of Staff in 1 and then in combo box 2 a list of pupils for that teacher is in the list
If they then select a differnet member of Staff in Combo box 1 a different list of pupils appears in combo box 2.

We are using vlookup with the combos.

Solution if possioble must not use vb okay with macros.

thanks
Stuart
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

as an alternative to the excellent suggestions already made, here is an alternative.

Create the two COMBO BOXES

In A2, A3.... enter the teachers names

D1, E1 .... enter the teachers names (or COPY-->PASTE SPECIAL -->TRANSPOSE)

Under each teacher enter the pupils names.

For the first Combo Box have the input range as A2:A3... and the cell link as A1.

In G1 enter this formula

=OFFSET($C$1,ROW()-1,$A$1)

and copy down as fas as necessary.

For the second Combo Box have the input range as G1:G3...

You will have to determine what to do with the results, you will also need to change cell refs as necesary.

Is this any use?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,158
Messages
5,600,054
Members
414,357
Latest member
Gemma_R

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top