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