| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I create drop boxes
I have been trying to create a drop box that when, Example: when I select
"Brick" that will generate a number 7 in a cell that will be calculated by a nother cell. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I create drop boxes
I think the easiest way may be data|validation and then =vlookup() in that other
cell. Debra Dalgleish describes both at: http://www.contextures.com/xlDataVal01.html and http://www.contextures.com/xlFunctions02.html Terry wrote: I have been trying to create a drop box that when, Example: when I select "Brick" that will generate a number 7 in a cell that will be calculated by a nother cell. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down boxes/tick boxes | Excel Worksheet Functions | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| How do I create drop-down list boxes from multiple lists/headers | Excel Worksheet Functions | |||
| How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
| How do I create a macro to return drop down boxes to first item i. | Excel Discussion (Misc queries) | |||
Linear Mode
