Consulting

Results 1 to 4 of 4

Thread: Always On Top

  1. #1

    Always On Top

    Hello

    I have a Userform with txtboxes and CommandButtons.

    On my "Hide" button I have got it that it hides the current userform and then opens a smaller one.

    Is there a way to have this always on Top, At the moment when I open my UserForm I have it so that Application.Visible=False (Hides Excel)

    Is there a way to have it so that the smaller userform is on top of all the other Windows Applications? Also I would like to tell the smaller UserForm that when it is opened to place itself in the top right corner of the screen.

    Is this possible?

    Its probably a really simple code, but dont know it lol

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    First one. Don't do it. It is intrusive and not a good practice.

    Second one. See http://www.cpearson.com/excel/FormPosition.htm
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    First one is only for personal use only, so I'm not bothered - Is it possible though?

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    If it is just for personal use, then why do you need it, you already have total control?

    I am sure it could be done with APIs, but I don't have an example to hand, or the time to create one.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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