How can I fix my listbox from not selecting the wrong item with different monitor zoom/display settings

Raymond 1 Reputation point
2022-05-13T15:03:07.13+00:00

I have a listbox on a sheet in my workbook and it is on our SharePoint. A couple of folks have different settings on the monitor they use it on and the multiselect does not work correctly. When you click on a specific item it picks something else and jumps. is there some VBA code or something I can use to fix this issue so anyone can use the listbox and select what the click on?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,627 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Hua-MSFT 27,506 Reputation points
    2022-05-16T06:28:45.907+00:00

    Hi @Raymond

    Welcome to Q&A forum ~

    Based on my research, your issue needs the VBA code help, but we are primarily responsible for general issues of Office.
    To help you better, I would add the related tag. Thanks for your understandings.

    Then here are 2 threads I found, "Last item in multiselect listbox only partly visible", "Excel ActiveX ListBox Shrinks with each update".
    According to the threads above, there is a Listbox Property called IntegralHeight whose default property is True that something to do with screen resolution and optimal display of listbox contents. Please set that to False to have a check.

    Besides, we can't run VBA code in Excel for the web, if there is a solution for this VBA code, the users need to download the workbook and open it with the desktop client.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


    0 comments No comments