Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box
Hi
I have created a dropdown box (Combo) and have initailised it by placing values in it via the Form_Load()Command eg lstOneCol.additem "Buses" The user thus selects a value from the list at runtime - now is when my VB memory fails me. The chosen option is in text form I need it in numericals so that I can perform a calculation on it eg the user choses "Buses" from the dropdown list. I then need to be able to relate this to a value i.e. 23 (miles to the gallon) with which I can put in equations etc. I just cannot remember how to do this THanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box
In Excel, you can do this:
Maybe you have a table with Buses 23 Cars 40 you could use a Vlookup formula res = Application.Vlookup(combobox1.Value,worksheets("Da ta").Range("A1:B20"),2,Fal se) -- Regards, Tom Ogilvy Davo wrote in message ... Hi I have created a dropdown box (Combo) and have initailised it by placing values in it via the Form_Load()Command eg lstOneCol.additem "Buses" The user thus selects a value from the list at runtime - now is when my VB memory fails me. The chosen option is in text form I need it in numericals so that I can perform a calculation on it eg the user choses "Buses" from the dropdown list. I then need to be able to relate this to a value i.e. 23 (miles to the gallon) with which I can put in equations etc. I just cannot remember how to do this THanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a combo box that is tied to another combo box? | Excel Worksheet Functions | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |