Listbox enlarges as entries are made until command buttons are covered.

TrainingExcellence

New Member
Joined
Apr 6, 2017
Messages
10
Office Version
  1. 365
I have a form with a listbox. The form is set up so that I type entries into a series of text- and comboboxes, and then press a command button to add the values into the listbox (see picture: https://campbellsoup-my.sharepoint....xHob3maqYUzOQBo3sPbdjrz_zr-0qziXz8zQ?e=g7cOuC). The problem is each time an entry is added to the listbox, the box expands and begins to conceal the command buttons. This is in Excel 2019. I built this form in 2013, and it worked fine, but as soon as I upgraded to 2013, this problem started happening. Any ideas?

Thanks!
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Change the IntegralHeight property of the listbox to False.

3f791d24a2203a885d2b22248ed65428.jpg
 
Upvote 0

Forum statistics

Threads
1,214,649
Messages
6,120,730
Members
448,987
Latest member
marion_davis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top