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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Change the IntegralHeight property of the listbox to False.

3f791d24a2203a885d2b22248ed65428.jpg
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

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