Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I find a handle number of controls on Userform?
Hello everyone,
I knew how to find a handle number of userform or application object. as following: ------------------------------------------------------------------------------------------------ Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long Dim h As Long h = FindWindow(vbNullString, Application.Caption) If h = 0 Then MsgBox "Sorry, I could not find that window" Unload Me Else MsgBox "The Handle to that Window is: " & h End If ------------------------------------------------------------------------------------------------ but I want to know how to find a handle number of an image control on the Userform. How can I find a handle number of controls on the Userform? Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I find a handle number of controls on Userform?
All of the MSForms ActiveX controls are windowless, so they don't have window handles that you can acquire in this manner. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "sjoo" wrote in message ... Hello everyone, I knew how to find a handle number of userform or application object. as following: ---------------------------------------------------------------------------- -------------------- Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long Dim h As Long h = FindWindow(vbNullString, Application.Caption) If h = 0 Then MsgBox "Sorry, I could not find that window" Unload Me Else MsgBox "The Handle to that Window is: " & h End If ---------------------------------------------------------------------------- -------------------- but I want to know how to find a handle number of an image control on the Userform. How can I find a handle number of controls on the Userform? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: mouse cant find cell handle to drag/move | Excel Discussion (Misc queries) | |||
Number of Decimals Excel can Handle | Excel Discussion (Misc queries) | |||
How do I handle error conditions with the FIND command? | Excel Worksheet Functions | |||
Limit of number which sin() can handle? | Excel Worksheet Functions | |||
What order does VBA look at userform controls? | Excel Programming |