| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make drop-down lists show more rows
I'd need to make the drop-down list displayed show more
rows than the default. Any ideas? TIA Paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to make drop-down lists show more rows
use additem
For x = 1 To 200 ComboBox1.AddItem x Next x "paul" wrote in message ... I'd need to make the drop-down list displayed show more rows than the default. Any ideas? TIA Paul |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to make drop-down lists show more rows
Paul,
Set the ListRows property, either in design, or in code. -- HTH Bob Phillips "paul" wrote in message ... I'd need to make the drop-down list displayed show more rows than the default. Any ideas? TIA Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make coloured drop down lists in Excel? | Excel Worksheet Functions | |||
| Trying to make multiple drop down lists that excludes cell in a ra | Excel Discussion (Misc queries) | |||
| Shortcut to make a drop-down LOV show during data entry? | Excel Discussion (Misc queries) | |||
| Drop down lists show button? | Excel Worksheet Functions | |||
| Drop down lists are displaying end of list, how to make it top? | Excel Worksheet Functions | |||
![paul[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
