ExcelBanter - How to make drop-down lists show more rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to make drop-down lists show more rows (https://www.excelbanter.com/excel-programming/271958-how-make-drop-down-lists-show-more-rows.html)

paul[_6_]

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

Mike Tomasura

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

Bob Phillips[_5_]

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

All times are GMT +1. The time now is 04:16 AM.