How To Get Listbox hwnd

[yinkajewole]

I got a code that works well in vb, but the code uses listbox hwnd. this property do not exist in vba, is there a workaround for this?

 

[Rick Rothstein]

I got a code that works well in vb, but the code uses listbox hwnd. this property do not exist in vba, is there a workaround for this?

You might be able to find something useful at this link. In one of the messages, it show the retrieval of what the programmer called the "local hwnd". If you go this route, back up your workbook often as you will be playing with subclassing and hooks which if not coded correctly (think typos here) could crash the entire Excel session.

https://social.msdn.microsoft.com/F...ouse-scroll-in-userform-listbox-in-excel-2010