Thread: Combo Box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Davo[_2_] Davo[_2_] is offline
external usenet poster
 
Posts: 1
Default 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.