Mouse scroll in UserForm ListBox - runtime error 91

Hi All,

I have used this code from Peter Thornton from this post and works perfectly for my Combi and List boxes, but when I have the visual basic editor open I get a runtime error 91 - Object variable or block variable not set. When the visual basic editor is closed the error does not appear.

https://social.msdn.microsoft.com/Forums/en-US/7d584120-a929-4e7c-9ec2-9998ac639bea/mouse-scroll-in-userform-listbox-in-excel-2010

Anyone got any ideas as why this happens only when the visual basic editor is open?

Thanks

I will not tell you why this is so. I can only advise you not to do it in the future. If you need to edit your code and / or test while it is executing, disable the hook first. You know this works, so turn it off while testing.

Artik

Thanks Artik, I was just curious as to why the runtime error 91 appears only when the VB editor is open.

Hi,

as the error occurs according to your code design …

Ok, so I'm assuming that means something is wrong with the code?

I'm no way an expert and have copied a lot of the code from the link I provided in the first post.
Can anyone have a look at the code and suggest anything that could be causing the runtime error 91 from this?

If I press the debug button, it points to "HookListBoxScroll Me, Me.PartsListBox". If I then press the stop or End button, Excel crashes.

Just to let you know this will run in 64Bit Excel only, not 32Bit (I only use 64Bit Excel)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks very much,