question

Raymond-5694 avatar image
0 Votes"
Raymond-5694 asked emilyhua-msft edited

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

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?

office-vba-devoffice-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered

Hi @Raymond-5694

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.