ExcelBanter

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

Lori

drop down box
 
I have created a worksheet with several drop down boxes. Is there any way the
user can select more than one item in the drop down box ?

Jim Thomlinson

drop down box
 
You need to define drop down box. If you mean a list box (not combo box or
data validation) then yes. Now it just depends where you got the list box
from. If it was from the control toolbox then there is a multi select
property (right click the control and select perperties) that you can set. If
it was from the forms toolbar then there is a Format Control - Control -
Selection Type that you can set.
--
HTH...

Jim Thomlinson


"Lori" wrote:

I have created a worksheet with several drop down boxes. Is there any way the
user can select more than one item in the drop down box ?


Debra Dalgleish

drop down box
 
You can do that with programming. There's an example he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0017 - Select Multiple Items from
Dropdown List'


Lori wrote:
I have created a worksheet with several drop down boxes. Is there any way the
user can select more than one item in the drop down box ?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 03:01 AM.

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