Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Application Window States (97 SR2)

    Does anyone know of a way to make my excel application move with my userform?

    Also, I know how to resize the window via code, but is there a simple way to say, userform = application, as far as the window size is concerned?

    Thanks in Advance!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Application Window States (97 SR2)

    About the only way that I could think of is to add some code to the userform's resize event that sets Application.height=userform.height, application.left=userform.lett, etc.

    If you want to move the application, you might have to put the same code in the userform mouseup event, which is the only way I can think of to test for the userform having been moved.

    Hope that helps

    Jon

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Application Window States (97 SR2)

    Drk,

    If your aim is have the application behind your userform, and hence not visible, you might try Application.Visible = False in the userform Initialize event, and in the Terminate event restore with Application.Visible = True.

    Just a thought

    Andrew C

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •