Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get drop down menu's to show different background colour | Excel Discussion (Misc queries) | |||
What do the underlined letters in the drop down menu's mean? | Excel Discussion (Misc queries) | |||
Drop Down menu's | Excel Discussion (Misc queries) | |||
Font Size in Drop Down Menu's | Excel Discussion (Misc queries) | |||
Drop Down Menu's | Excel Discussion (Misc queries) |