Combo Box

[Davo]

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.

 

[Tom Ogilvy]

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("Data").Range("A1:B20"),2,Fal
se)