Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Drop-down options
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Drop-down options
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. -- Biff Microsoft Excel MVP "John1791" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Linking options | Setting up and Configuration of Excel | |||
Modifying drop-down box options and formats | Excel Discussion (Misc queries) | |||
Drop-down menu options | Excel Discussion (Misc queries) | |||
How do I set up a drop down box in Excel with a list of options f. | Excel Discussion (Misc queries) |