I have a combobox on a Userform in Word 2010. I managed to find a code to get the mousewheel to scroll in the combobox. I used the events "Enter" and "Exit" with the ComboBox and everything works fine. However, if I keep the userform open and I decide to move the mouse to another application such as a web browser the scroll doesn't work because it is still hooked on the userform and cannot get it unhooked unless I close the userform (which I don't want to).
Unfortunately there is no LostFocus events for Userforms. Therefore, I'm wondering if a workaround solution is possible to emulate the lost focus scenarios to allow the mousewheel scroll to work if the user is on another application.
for the sake of clarity I have attached the file. Basically if you open the combobox in Word the scrolling works fine. Let's assume a user jumps to another application such as a website without closing the userform on Word. The problem is that the scrolling won't work on the other applicaiton because it remained hooked on the userform. Hence my need to find a way to let the system know that the focus is lost on the Word userform so that the scrolling is automatically unhooked there and becomes available on the new open application.