Re: api - tracking LostFocus or Exit event of a combobox

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


A ComboBox on a UserForm has both an Enter and Exit event.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"sebastienm"
<sebastienm@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message
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>

.

Relevant Pages

  • Re: New Combobox disabled
    ... By main window, do you mean the Word Application window? ... I meant the UserForm window. ... the UserForm is where the combobox needs to reside... ... And finally, if you want to create a ComboBox and populate it at run-time in a MultiPage, you can use the 'Controls' collection too, of the specified Page. ...
    (microsoft.public.vb.winapi)
  • RE: Select Text Files from Combobox
    ... Draw your combobox on the userform. ... Click the View Code button above the Project Explorer Window and paste this ... Private Sub UserForm_Activate ... Now you will need to add code to your project to show the userform. ...
    (microsoft.public.excel.misc)
  • Re: api - tracking LostFocus or Exit event of a combobox
    ... I don't have access to the Combobox directly from the Userform; ... window 's class using Spy+, it seems like the combobox doesn't have a window ... assicioted with it (unlike the listbox or a frame). ...
    (microsoft.public.excel.programming)
  • Re: api - tracking LostFocus or Exit event of a combobox
    ... I don't have access to the Combobox directly from the Userform; ... window 's class using Spy+, it seems like the combobox doesn't have a window ... assicioted with it (unlike the listbox or a frame). ...
    (microsoft.public.excel.programming)
  • RE: Data table function - A dropdown list replacement for VLookup.
    ... To do this you would be well served by a UserForm which we will create now. ... This will create a ComboBox control on the form. ... “Typing in the selection box will bring matching choices, ... The above code that we just pasted into the code window will take the data ...
    (microsoft.public.excel.worksheet.functions)