I find that the combobox from the Control Toolbar is much better to us
than the one from the Forms toolbar.

You need to add a *CASE* Statement to the *Change_Event* of th
combobox. I have provided an example below. The example below assume
that there are three choices in the combobox....they are the values *A
B,* and *C*


PRIVATE SUB COMBOBOX1_CHANGE()

VSELECTION = COMBOBOX1.TEXT

SELECT CASE VSELECTION

CASE \"A\"

MSGBOX (\"YOU HAVE SELECTED \" & \"A\")

CASE \"B\"

MSGBOX (\"YOU HAVE SELECTED \" & \"B\")

CASE \"C\"

MSGBOX (\"YOU HAVE SELECTED \" & \"C\")

END SELEC






Rolli

--
Message posted from http://www.ExcelForum.com