Linking Drop-down options

[Guest]

I am trying to link multiple cells and can not figure out how to do this
properly.

Example:

One cell has a drop down menu that has choices of: circles, squares, or
rectangles. But the next cell requires a number within a certian range, but
this range is different depending on which of the first cell was chosen.

circles have to be between 1 and 5
squares have to be between 3 and 9
and rectangles have to be between 17 and 35

I can not figure out how to do this....can anyone help?

Thanks,

John

 

[T. Valko]

So, you want dependent drop downs?

Try this:

List all the numbers in a range of cells:

F1:F9 = 1,2,3,4,5,6,7,8,9
F10:F28 = 17,18,19...35

Give the range F1:F5 the name Circles
Give the range F3:F9 the name Squares
Give the range F10:F28 the name Rectangles

Assume the main drop down list is in cell A1 and has these selections
available: Circles, Squares, Rectangles.

As the source for the dependent drop down use this formula:

=INDIRECT(A1)

You might also want to do something about what is displayed in the dependent
drop down cell when a different selection is made from the main drop down.
For example, you select Rectangles from the main list then you select 30
from the dependent list. You then make a different selection from the main
list, Circles. 30 still appears in the dependent cell but this is not a
valid selection for Circles.

You can "fix" this a couple of ways. Use an event macro to clear the
dependent cell when a change is made to the main list or use conditional
formatting to "hide" the invalid selection in the dependent cell.

Post back if you want to use one of those options and need help figuring it
out.