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!
|