View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default return value from combo box

There are two types of combo boxes. For what you wnat to do i would recomend
getting the combo box from the controls toolbox (not the forms toolbar). When
you add this to a sheet it becomes embedded in the sheet. Right click on the
combobox and select properties. Give the combobox a descriptive name (like
cbxLetters).

Now in the code you can refer to it with

Sheet1.cbxLetters.Value

(Assuming the combo box is in sheet1)
--
HTH...

Jim Thomlinson


"tbaam" wrote:

How do I find out what a user selected from a combo list. For example, if the
combo box list is A, B or C and they select B is there a way for me to
determine that in a macro.

Thanks!