Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combobox exit event search error | Excel Programming | |||
MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
defining an event procedure (lostfocus) that works on a column range | Excel Programming | |||
ComboBox Exit | Excel Programming | |||
combobox exit event | Excel Programming |