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

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