How to make drop-down lists show more rows

paul · Jul 17, 2003

I'd need to make the drop-down list displayed show more
rows than the default. Any ideas?

TIA
Paul

Mike Tomasura · Jul 17, 2003

use additem

For x = 1 To 200
ComboBox1.AddItem x
Next x

Bob Phillips · Jul 17, 2003

Paul,

Set the ListRows property, either in design, or in code.

How to make repeating drop-down lists?	2	Jul 3, 2022
Drop down list control value in vba	2	Mar 8, 2022
Drop down lists in seperate columns	5	Jan 23, 2020
How can I give customized drop down in Ms Forms online or refer dropdown from excel list	0	Nov 12, 2021
Link a text box based on drop down box with four options MS Word 365	0	Aug 24, 2021
Excel 2013: New row added automatically but first 2 columns Drop down lists not available...	0	Oct 8, 2018
MS Project Center-Autolink column fields	0	Jul 6, 2022
drop down list	1	May 19, 2016

Ask a Question