![]() |
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 |
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 |
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