Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting Combo boxes to change options based on other Combo boxes. Ancient Wolf New Users to Excel 1 March 27th 09 06:29 PM
Selecting subsets using combo boxes or list boxes CLamar Excel Discussion (Misc queries) 0 June 1st 06 07:43 PM
Questions on combo boxes and list boxes. Marc New Users to Excel 1 March 14th 06 09:40 AM
Combo Boxes and Tick Boxes turner2000[_2_] Excel Programming 0 September 29th 04 09:09 PM
Combo Boxes and Tick Boxes turner2000 Excel Programming 0 September 28th 04 10:01 PM


All times are GMT +1. The time now is 07:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"