Share via

Excel Listboxes not displaying correctly

Anonymous
2024-10-31T16:17:13+00:00

Hello,

I need help with a couple of listboxes for a client deliverable. I resized the listbox so it would stop becoming incredibly small every time the file was reopened. But now I have a weird new issue with them where the scrollbars are really wide or unusable. The listbox autocorrects as soon as we go to Designer Mode and click on it, but hoping to find a solution where we don't need to do that every time someone saves and reopens the file. The listbox with the weird shades of gray has the properties box with a height of 78.75. The listbox with the giant scroll bar has the properties box with a height of 74.25.

Any help is appreciated! Thank you!

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2024-10-31T19:37:13+00:00

    Are you using vba in this file?

    ActiveX controls are notoriously badly behaved when on a sheet.

    We could write a bit of code to correct the properties in some event handler.

    Was this answer helpful?

    0 comments No comments