combobox limit to list

[tmort]

I'd like to limit limit the choices in an Excel combobox to the two items in the list.

I can specify exact match, but users can still enter text and get an error. What I'd like would be the equivalent to the limit to list proprty in Access.

I'll settle for some sort of error handler. I think it was error 380. When I try to put an error handler on the before or after update property nothing happes.

I notice that the error message is labeled form so maybe it is a form error, but, I don't see a form error event.

Thanks for any help

[TommySzalapski]

Go to the properties of your combobox (right click and click "properties") and change the "Style" to "2 - fmStyleDropDownList"

[Tom Ogilvy]

Combobox.Style = fmStyleDropDownList

from help on the style property for fmStyleDropDownList (2)

The ComboBox behaves as a list box. The user must choose a value from the
list.

--
Regards,
Tom Ogilvy


"tmort" <[email protected]> wrote in
message news:[email protected]...
>
> I'd like to limit limit the choices in an Excel combobox to the two
> items in the list.
>
> I can specify exact match, but users can still enter text and get an
> error. What I'd like would be the equivalent to the limit to list
> proprty in Access.
>
> I'll settle for some sort of error handler. I think it was error 380.
> When I try to put an error handler on the before or after update
> property nothing happes.
>
> I notice that the error message is labeled form so maybe it is a form
> error, but, I don't see a form error event.
>
> Thanks for any help
>
>
> --
> tmort
> ------------------------------------------------------------------------
> tmort's Profile:
http://www.excelforum.com/member.php...o&userid=21053
> View this thread: http://www.excelforum.com/showthread...hreadid=389992
>

[STEVE BELL]

You could add a check in your code that looks at the
combobox.value and checks to see if it is in the list.

If combobox1.value = 1 or combobox1.value = 2 then
' continue code
Else Msgbox "You did not make an acceptable selection. Please try again"
' code to restart the procedure
End If

--
steveB

Remove "AYN" from email to respond
"tmort" <[email protected]> wrote in
message news:[email protected]...
>
> I'd like to limit limit the choices in an Excel combobox to the two
> items in the list.
>
> I can specify exact match, but users can still enter text and get an
> error. What I'd like would be the equivalent to the limit to list
> proprty in Access.
>
> I'll settle for some sort of error handler. I think it was error 380.
> When I try to put an error handler on the before or after update
> property nothing happes.
>
> I notice that the error message is labeled form so maybe it is a form
> error, but, I don't see a form error event.
>
> Thanks for any help
>
>
> --
> tmort
> ------------------------------------------------------------------------
> tmort's Profile:
> http://www.excelforum.com/member.php...o&userid=21053
> View this thread: http://www.excelforum.com/showthread...hreadid=389992
>

[tmort]

Thanks,

Stype 2 works fine for my purposes but I'm glad to learn of the other check value method too