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?
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 people are following this question.
