Combo boxes 101
 

Hello all,

A simple enough combo box question. I have a list of four options that will
correspond to individual macros that I want to run. Is it better to use combo
boxes from the Forms toolbar or the Controls toolbar? I would like to find
some example of code on how to do this. My preference would be to use a combo
box from the Forms toolbar but if it is easier with a combo box from the
Controls toolbar, so be it.

thanks in advance

Charles Ames - UO

Combo boxes 101
 

Either will do the job.

If you use forms, you could use a linked cell to determine what has been
selected.

If you use controls, you can test the ListIndex property.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"amescha" wrote in message
...
Hello all,

A simple enough combo box question. I have a list of four options that
will
correspond to individual macros that I want to run. Is it better to use
combo
boxes from the Forms toolbar or the Controls toolbar? I would like to find
some example of code on how to do this. My preference would be to use a
combo
box from the Forms toolbar but if it is easier with a combo box from the
Controls toolbar, so be it.

thanks in advance

Charles Ames - UO