ExcelBanter - make dropdown list greater than 8 rows

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

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

- - make dropdown list greater than 8 rows (https://www.excelbanter.com/excel-programming/441266-make-dropdown-list-greater-than-8-rows.html)

SteveZmyname

make dropdown list greater than 8 rows

Hello
How can I make my dropdown list 12 rows instead of only 8?
thanks for any help

ozgrid.com

make dropdown list greater than 8 rows

For a Forms Combo Box right click and choose Format Control-Control tab

For an ActiveX ComboBox right click and choose Properties and adjust
ListRows.

--
Regards
Dave Hawley
www.ozgrid.com
"SteveZmyname" wrote in message
...
Hello
How can I make my dropdown list 12 rows instead of only 8?
thanks for any help

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