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 |