View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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