Are VBA userforms always child of Windows desktop?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "RB Smissaert" <bartsmissaert@xxxxxxxxxxxxxxxx>
Date: Sat, 2 Jun 2007 11:56:15 +0100

Had a look at some code in the the book of Bullen et Al, Professional Excel Development.
I thought that it was suggested that VBA Userforms are the children of the Excel
desktop window, but it appears that this is not the case and that these windows are the
direct children of the Windows desktop.
Is this always the case?
I am interested in this as I need the form's hwnd.
I used to do this with the FindWindow API and this only needs the form's class name
(ThunderDFrame or ThunderXFrame) and the form's caption.
Possibly it is faster (not tested yet) to get this hwnd with the FindWindowEx API, but then
I need to know for sure that the Windows desktop is indeed always the parent of this form.
This is directly after the window is created as I know I can alter the parent window of a form.
Thanks for any advice/insight.

RBS

.

Follow-Ups:
- Re: Are VBA userforms always child of Windows desktop?
  - From: NickHK
- Re: Are VBA userforms always child of Windows desktop?
  - From: Peter T

Prev by Date: Re: EMail Small Message from Excel
Next by Date: Re: "application.filesearch" object doesn't support the this property
Previous by thread: Re: EMail Small Message from Excel
Next by thread: Re: Are VBA userforms always child of Windows desktop?
Index(es):
- Date
- Thread

Relevant Pages

Re: Are VBA userforms always child of Windows desktop?
... Excel ... I need to know for sure that the Windows desktop is indeed always the ... This is directly after the window is created as I know I can alter the ... parent window of a form. ...
(microsoft.public.excel.programming)
Re: Are VBA userforms always child of Windows desktop?
... When I load a modeless userform then in Spy++ the treeview suggests that the form is a child of the desktop. ... Retrieves the parent window. ...
(microsoft.public.excel.programming)
Re: how to call a java script function in a child window from the
... The htm in the parent window and needs ... The child window displays a contact form that is to be ... I was trying to from the parent window script> ...
(microsoft.public.frontpage.programming)
Re: How to have a Perl script emulate a keystroke to another application
... I used Win32::GuiTest to SendKeys to applications. ... Finds the window handles of the windows matching the specified ... parent - the parent window of the button ... BOOL SetForegroundWindow* ...
(comp.lang.perl.misc)
Re: Detect a forms window mode
... By looking at the window classes of the form and of its parent window, ... I can tell whether the form is popup or not. ... 'Returns the handle of the parent window of the specified window. ... Private Sub Form_Load ...
(microsoft.public.access.modulesdaovba)