Handle to userform

[alimcpill]

Can anyone give me some hints on how to get a handle to a userform please? In full vb I believe you can use userform.hwnd, but this property isn't there in VBA. Will I have to make some API calls to get it?

[Killian]

You can declare this in your user form code:

Private Declare Function GetActiveWindow Lib "user32.dll" () As Long

then get handles to it when its active with this:

dim hWnd as Long
hWnd = GetActiveWindow()

Hope that helps

[mark007]

This should help:

http://www.thecodenet.com/articles.php?id=2

[alimcpill]

thanks very much guys, both your answers came in very handy!