ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Expanding Viewable List in Drop Down Menu's (https://www.excelbanter.com/excel-programming/381894-expanding-viewable-list-drop-down-menus.html)

ColinSHCD

Expanding Viewable List in Drop Down Menu's
 
Hi, I was wondering if anyone knew how I could expand the viewable items
shown in a drop down menu... I have a drop down menu with a large amount of
items and would like to show a larger porion of the list to choose from when
the drop down menu button is clicked (currently is shows a small number of
the items and in turn takes a long time to scroll through for a user to pick
/ find the item from the list he/she desires.
Thank You for your help.
Colin

Mike

Expanding Viewable List in Drop Down Menu's
 
It depends which type used.

From the forms toolbox. Right click - format control - Control and then set
the lines you want.

From the Control toolbox. Right click - Select design mode - and then right
click and properties. Set listrows to desired value.

"ColinSHCD" wrote:

Hi, I was wondering if anyone knew how I could expand the viewable items
shown in a drop down menu... I have a drop down menu with a large amount of
items and would like to show a larger porion of the list to choose from when
the drop down menu button is clicked (currently is shows a small number of
the items and in turn takes a long time to scroll through for a user to pick
/ find the item from the list he/she desires.
Thank You for your help.
Colin


Jim Rech

Expanding Viewable List in Drop Down Menu's
 
Assuming you meant that you have a drop down control rather than a menu,
check out the control's DropDownLines property.

--
Jim
"ColinSHCD" wrote in message
...
| Hi, I was wondering if anyone knew how I could expand the viewable items
| shown in a drop down menu... I have a drop down menu with a large amount
of
| items and would like to show a larger porion of the list to choose from
when
| the drop down menu button is clicked (currently is shows a small number of
| the items and in turn takes a long time to scroll through for a user to
pick
| / find the item from the list he/she desires.
| Thank You for your help.
| Colin




All times are GMT +1. The time now is 05:24 PM.

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