search

cristianbuse / VBA-UserForm-MouseScroll

Use the Mouse Scroll Wheel to scroll VBA UserForms and Controls
MIT License
70 stars 12 forks source link

ListView? #7

Closed asdfghjkl2016 closed 2 years ago

asdfghjkl2016 commented 2 years ago

Hi, this is a great Project! Thank you! :) How can I use this with ListView-Control (SP6)? Greetings Max

cristianbuse commented 2 years ago

Hi Max,

I am not familiar with ListView. Probably because it's not working on x64. I presume you are using a 32bit version of Office.

It really depends on what events, properties and methods the control exposes. If it has a MouseMove event and some properties and methods that allow an easy manipulation of "rows" then it should not be too difficult to implement.

I will have a look next week, if time allows, and see if I can find it on a x32 version so I can form an opinion.

Cheers, Cristian

cristianbuse commented 2 years ago

Hi Max,

I managed to add a ListView control on a x32 Office and it seems that the mouse scroll works by default. It looks like you don't need my project to help you scroll a ListView. Is it not scrolling by default for you as well?

Cristian

asdfghjkl2016 commented 2 years ago

Hi Cristian,

thank you very much. I didn't know the Issue with x64, great for testing.
right, scroll down for yourself, thanks for the hint. But it only works if
the focus is on the ListView. Your project works regardless of the focus.
That's why I didn't notice it. But is there a solution for this (ListView
without focus)?

Max

cristianbuse commented 2 years ago

Hi Max,

I managed to find the library reference for x64 version as well. I guess it depends on the specific Office install.

Anyway, I've just pushed an update to the repository. You need to re-import the MouseScroll.bas and MouseOverControl.cls into your project and then change the value of the compiler constant DETECT_COMMON_CONTROLS (inside MouseOverControl.cls) to a value of 1 in order for scroll to work for a ListView control. I left it as 0 because most people don't use a ListView and so they won't have a library reference set to Microsoft Windows Common Controls thus they would get a compiler error if I left it as 1.

It won't be able to use the horizontal scroll or zoom features but at least the vertical scroll seems to work. Let me know if it works for you. Thanks!

Cristian

asdfghjkl2016 commented 2 years ago

Hi Cristian, thank you a lot, that's great, it works! Max

cristianbuse commented 11 months ago

Starting 76a384fb50d5bb2a5f6de49e287fe2fb774472d6 both Modal and Modeless forms are supported while debugging also works. There is no need to handle other controls separately (e.g. ListView) as they will work by default