ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   api - tracking LostFocus or Exit event of a combobox (https://www.excelbanter.com/excel-programming/396038-api-tracking-lostfocus-exit-event-combobox.html)

sebastienm

api - tracking LostFocus or Exit event of a combobox
 
Hi,

1. I am trying to capture the Exit or LostFocus event of a combobox on a
UserForm.
The Forms controls don't have a handle in vba and, while trying to find the
window 's class using Spy+, it seems like the combobox doesn't have a window
assicioted with it (unlike the listbox or a frame).
Any idea? Am i missing something?

2. If not direct way to (1)
To bypass the 'lack' of window for the combobox, i have placed the combobox
into a frame wrapped around it. However, i don't know how to get the handle
of the Frame. In spy++, the inside of the userform, the listbox, or the frame
have the same class (F3 Server 07600000).
Since I always show the frame programmatically (hidden most of the time) and
set its focus, I suppose i could use some sort of HitTest to determine the
window handle of the Frame. Then I could track the WM_KillFocus message
Any idea on a better approach?

Thank you for your help,

Sébastien
<http://www.ondemandanalysis.com

sebastienm

api - tracking LostFocus or Exit event of a combobox
 
Sorry about the duplicate post of the Question.
Please, post to the previous thread.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


All times are GMT +1. The time now is 05:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com