ListBox (ActiveX Controls) apear with two scroll bars for some users

[ThomasA83]

Hi,

I am working in Excel Pro Plus 2016 and have the issue, when some users open my file, that the scrollbar in the ListBox (ActiveX) shows odd and twice. This is not an issue on my own laptop nor a few other user's, and I cant figure out why this issue occur for some.

Users with issue look like this: https://ibb.co/mXCGtG

Users with no issues: https://ibb.co/k66btG

Any idea what could be wrong?

Brgds
Thomas

 

[Kyle123]

Are they on a worksheet or in a userform?

 

[ThomasA83]

On a worksheet

 

[Kyle123]

You might be a little out of luck then. ActiveX controls are notoriously buggy on worksheets (have a quick google to see just how widespread the display issues are) to the extent that you're better off avoiding them altogether in favour of Forms Controls - which are designed to be used on worksheets.

Typically the ActiveX issues are related to screen size/resolution, and appear to be worse where a user uses external monitors/multiple monitors/projectors with differing resolutions. There isn't a quick fix, but you could try disabling hardware graphics acceleration in Office if it's turned on.

 

[ThomasA83]

Hmmm, since the users is up to around 20-30 people, I prefer having a fix in Excel.

If I change to Forms Control, the possibilities are slim for add-ons, like hot-keys. I have around 700 possible entries, so without hotkeys if takes a while to scroll through the Form Control ListBox.

Any good other suggestions?

 

[Kyle123]

A userform?

 

[ThomasA83]

I will try search for how to create such, as have no experience in userforms.

 

[Kyle123]

Exactly the same way you did the controls on the sheet in all likelihood

 

[thisoldman]

Would toggling the drawing of the listbox help?

Listbox1.Visible = False
Listbox1.Visible =True

Or perhaps a more complete toggle:

' Hide
Listbox1.Height = 0
Listbox1.Width = 0
Listbox1.Top = 0
Listbox1.Left = 0
Listbox1.Visible = False

' Unhide
Listbox1.Height = 126.75
Listbox1.Width = 96.75
Listbox1.Top = 26.25
Listbox1.Left = 47.25
Listbox1.Visible = True

 

[ThomasA83]

Thanks, but where do I put in that code, and how?