Thread: Combo boxes 101
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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