Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down List Showing Two Cells Info
I am going to have a drop down list of numbers that will retreive size and
cost data. When the selection is made from the drop down list (001,002,003,004, ect), the detailed information associated with the drop down list number is located in the cells to the right of the drop down list numbers. The detailed list, containing the initial list of numbers (001,002,003,etc) will have a couple of columns of additional information shown to the right of the list of numbers. By choosing the drop down list number 002, the size associated with 002 will be shown in a cell as a result of the choice. As an example, if you choose the drop down box selection 002, the associated size will be 20 tons. The problem that I need to resolve is to show the user the size data at the same time they are selecting the numbers 001,002,003,etc. Is there a way to show two cells of information in a named list? Would I be better off to approach the problem with a different approach? Any help would be appreciated, JAD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down List Showing Two Cells Info
JAD,
I am assuming you are using a activeX combobox. By named list do you mean a named range? If not use the range in the properties of the combobox- ListFillRange. Put in the range for example F9:G11. Set the ColumnCount to 2 and BoundColumn should be 1 or 2 depending on the one you want the user to see. "JAD" wrote: I am going to have a drop down list of numbers that will retreive size and cost data. When the selection is made from the drop down list (001,002,003,004, ect), the detailed information associated with the drop down list number is located in the cells to the right of the drop down list numbers. The detailed list, containing the initial list of numbers (001,002,003,etc) will have a couple of columns of additional information shown to the right of the list of numbers. By choosing the drop down list number 002, the size associated with 002 will be shown in a cell as a result of the choice. As an example, if you choose the drop down box selection 002, the associated size will be 20 tons. The problem that I need to resolve is to show the user the size data at the same time they are selecting the numbers 001,002,003,etc. Is there a way to show two cells of information in a named list? Would I be better off to approach the problem with a different approach? Any help would be appreciated, JAD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list not showing all the data.... | Excel Discussion (Misc queries) | |||
Drop down list showing different value | Excel Discussion (Misc queries) | |||
drop down list is not showing | Excel Discussion (Misc queries) | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
Prefill cust info from drop list into other cells | Excel Worksheet Functions |