ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Drop down menu (https://www.excelbanter.com/excel-worksheet-functions/27110-drop-down-menu.html)

Steve A via OfficeKB.com

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.

Debra Dalgleish

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



All times are GMT +1. The time now is 11:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com