#1   Report Post  
Steve A via OfficeKB.com
 
Posts: n/a
Default Drop down menu

Hard to explain but here goes. Is there a way to keep the items in a drop
down menu active. Meaning I have a drop down menu of four items. I want to
select two items and denote with an x. Am I making sense? Bacially if you
were asked a question and had to select from a drop down menu but could
have more than one answer.

Thanks.
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can select multiple items from a Listbox. To add a listbox from the
Forms toolbar:

To show the Forms toolbar, choose ViewToolbarsForms
Click the Listbox button, to activate it
Draw a listbox
Double-click on the listbox, and set its Selection type property to Multi.

Steve A via OfficeKB.com wrote:
Hard to explain but here goes. Is there a way to keep the items in a drop
down menu active. Meaning I have a drop down menu of four items. I want to
select two items and denote with an x. Am I making sense? Bacially if you
were asked a question and had to select from a drop down menu but could
have more than one answer.

Thanks.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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
Drop down menu MGC New Users to Excel 2 May 10th 05 01:21 PM
How do I set up a drop down menu within a drop down menu? Rob Excel Discussion (Misc queries) 1 April 12th 05 06:02 PM
Drop down menu Pong Excel Discussion (Misc queries) 12 March 22nd 05 09:34 PM
Drop down menu Ron Excel Discussion (Misc queries) 3 March 4th 05 11:08 PM
help with drop down menu data wilecoyote Excel Discussion (Misc queries) 1 February 23rd 05 05:06 PM


All times are GMT +1. The time now is 02:28 AM.

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

About Us

"It's about Microsoft Excel"