List Box Selections Outputting Multiple Selections with One Click

Hi all,

I have something weird happening to some list boxes located within a form made in the VBE. I have 4 list boxes in total and when I select a value from them, I will have to double click the value just ot highlight it. Also, if I select the 3rd from the top (in two list boxes), multiple selections will be made. The form in question is called frmTool2.

Hello Mordred,

I can not run the workbook on my system but I did look at the code. I notice you have a reference set to a RefEdit control. While these controls work well in applications, they are not very reliable when used on VBA UserForms. I would remove the control from your project, modify the code to work around its absence, and try it again.

Hi Leith,

Thanks for that. I don't see a reference to RefEdit anywhere within my code but I am looking.

Hello Mordred,

It was listed in the VBA references as missing in my workbook. Open the VBIDE , go to Tools > References... and check the list. If it is there then it will have a check mark next to it. If not, it will say MISSING:

Thanks Leith, I deselected it and hit ok so now it isn't being referred to. However, 2 of the 4 listboxes still double select from one selection. Mayhap this is an issue that regards Excel controls.

Hello Mordred,

Perhaps it is since the code has no references to worksheet events nor UserForm events which might cause that behaviour. It could also be the workbook is partially corrupted. Have you tried creating a new workbook and copying the code into it to see if it behaves the same?

Maybe I'll recreate the workbook and start again, thanks Leith for the advice!

Hi Mordred,

If you wrap the listboxes with Frame controls rather than with Label controls, the problem disappears. The "look" is exactly the same.

So I remade my workbook and used frames like Colin suggested and all is good in my hood! Thanks all for your insight!