View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default ZOrder of two forms

OfficeHacker,
Have you looked into using .Move so they are both visible, or .Hide ?

NickHK

"OfficeHacker" wrote in message
...
Here's the scenario:
I have two forms to display on the screen: Form1 and Form2. The Form2 is
displayed after the user clicks a button on Form1 (which is already
displayed). Form2 is automatically displayed in front of Form1. Both forms
are loaded modeless (you can't load a second form if the first is modal).

Here's the problem:
I need the capacity to change the ZOrder of the two forms without

unloading
either of them. That is I need to programmatically force Form1 to be in

front
of Form2, or alternatively Form2 in front of Form1.

I have not been able to find a way to do this. The forms themselves to not
have a ZOrder property. The only other way I can think of is via an API
though I'm not sure which API function would solve this.

Any ideas?