10 Comments

1. 

   monirulccr on April 30, 2020 at 11:04 am

   I was copy this code and just pase in my new module.

   Wrong number of arguments or invalid property assignment .

   And focus to the “UnhookListBoxScroll”

   what is my mistake? can you help me?

   Thanks

   Reply
   • 

     Dan Strong on May 2, 2020 at 5:40 pm

     Hi monirulccr,
     You may want to try to see if this works on the downloaded workbook okay on your computer, and if so, first see if the way it’s being used is the same as the demo workbook. Also, make sure any compile errors are gone before utilizing this tool. You can check using Debug->Compile VBAProject
     Hope that helps.
     Thanks
     Dan

     Reply
2. 

   belitavla on May 29, 2020 at 9:24 pm

   Hi,
   I’ve tried the downloaded workbook, but the scroll with the mouse wheel doesn’t work.
   I have office 365 with 64bits Excel version and 64bits Windows version.
   Do you have any idea why the downloaded workbook doesn’t work for me?

   Thank you,
   Isabel Vala

   Reply
   • 

     Dan Strong on August 13, 2020 at 7:02 pm

     Hi belitavla,
     I’m not sure why it’s not working for you. Do you have a 32 bit computer that it is working on? Do you have macros enabled?
     Thanks
     Dan

     Reply
3. 

   vhesap on June 4, 2020 at 12:26 am

   Hi Sir,

   Its worked.

   Thank you so much.

   Reply
   • 

     Dan Strong on June 12, 2020 at 2:32 pm

     So glad it’s working for you, vhesap!! 👍

     Reply
4. 

   zaki on August 5, 2020 at 5:48 am

   Been looking for something that can improve productivity and this is great. Looking for a way to highlight item in list as pointer move over it and so far code that I’ve had seems to get offset as the list get longer or shorter. So, I need to see how it is done here.

   Now I can add scroll feature too. Great stuff here 🙂

   Reply
   • 

     Dan Strong on August 8, 2020 at 9:43 pm

     Hi zaki,
     So glad it is helpful. I’m working on an advanced series to show people a new set of controls that will blow their minds. It’s not ready yet, but I can’t wait to show you. It has hover capabilities and much more without complicated code for pointers, etc.
     I’ll keep you posted.
     Thanks
     Dan

     Reply
5. 

   ryan.wherry on October 8, 2020 at 6:17 pm

   I downloaded the code and it works well. However, anytime VBA IDE goes into break mode, be it from an inserted breakpoint or from a runtime error, Excel crashes. Any thoughts?

   Reply
   • 

     Dan Strong on October 29, 2020 at 12:46 pm

     Hi Ryan,
     I’m not sure. When no macros are running or in break, are there any outstanding syntax issues that arise when you use Tools->Compile VBAProject?
     Oftentimes WinAPI calls are less than forgiving when they encounter any errors and rather than helping you debug them like regular vba code, they just want the application to freak out and crash. That’s why I ask.
     Thanks
     Dan

     Reply