make dropdown list greater than 8 rows

[SteveZmyname]

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

 

[ozgrid.com]

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.

 

[Lee Li Fong]

I can change the drop down lines to 12 in the Format Control dialog box.

Lee Li Fong
http://smartusemicrosoftoffice.blogspot.com/

 

[SteveZmyname]

thanks everyone that defenitely helps!