Hi, this problem has been bugging me for some time now and I'd appreciate any help you can give:
I've got a sheet containing cells with validation lists. What I'd like to do is to know which list item the mouse cursor is hovering on when the list is open. Since Excel doesn't have any properties to monitor validation lists, I have to try with windows API. I've checked with a program called Winspector what happens when I open a validation list and here's what I get: "Window 00080786, class EXCEL:, created" when opening and "Window 00080786, class EXCEL:, destroyed" when closing the list. After that I tried getting a handle to the class with FindWindowEx and even WindowFromPoint, but no dice... any advice?
Thanks for any ideas!
I've got a sheet containing cells with validation lists. What I'd like to do is to know which list item the mouse cursor is hovering on when the list is open. Since Excel doesn't have any properties to monitor validation lists, I have to try with windows API. I've checked with a program called Winspector what happens when I open a validation list and here's what I get: "Window 00080786, class EXCEL:, created" when opening and "Window 00080786, class EXCEL:, destroyed" when closing the list. After that I tried getting a handle to the class with FindWindowEx and even WindowFromPoint, but no dice... any advice?
Thanks for any ideas!