return value from combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tbaam - 23 Mar 2006 21:49 GMT

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!

Reply to this Message

Jim Thomlinson - 23 Mar 2006 21:49 GMT

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)

Signature

HTH...

Jim Thomlinson

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

Reply to this Message

tbaam - 23 Mar 2006 22:16 GMT

I may have taken on more then I can handle but this is really what I am
trying to do.

I have a spreadsheet that has active filters being used. I am trying to make
a user form such that each combox is actually one of the possible choices in
each of the filters.

For example Column A has a choice of Jan. or Feb.
Column B is Spring Summer Winter or Fall

my user form has two combo boxes...one is Jan/Feb the other is
Spring/Summer/Winter/Fall

so when a use selects Jan spring the spreadsheet will filter that infor.

I already have the macro that filters etc....

So I thought if I could create the form and then read the choices all my
user ever needs to see is the form and the results.

> 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
[quoted text clipped - 13 lines]
> >
> > Thanks!

Reply to this Message