Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What you are describing is a 2 column combobox. Create the combobox and in
its properties set the columncount to 2. If you want to hide the numeric values from your users set its column's width to zero. To refer to the selected value from code it is Combobox1.Column(0) for the first column, Combobox1.Column(1) for the second column. -- - K Dales " wrote: I am trying to create a drop-down list of materials and would like to assign different numeric values to each material,which will be used in calculations i.e. Under drop-down list of Materials, Wood=1, Steel=2, etc. Please help!! -Aarthi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
drop down menu that allows for text to be entered | Excel Discussion (Misc queries) | |||
Counting Text from Drop-down menu | Excel Worksheet Functions | |||
drop down list and adding numeric values to text | Excel Discussion (Misc queries) | |||
Assigning text values to numeric fields | Excel Discussion (Misc queries) | |||
assigning macros to a text link or create a drop down box | Excel Programming |