PDA

View Full Version : Always On Top



wildpianist
10-30-2007, 03:50 AM
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

Bob Phillips
10-30-2007, 05:00 AM
First one. Don't do it. It is intrusive and not a good practice.

Second one. See http://www.cpearson.com/excel/FormPosition.htm

wildpianist
10-30-2007, 07:26 AM
First one is only for personal use only, so I'm not bothered - Is it possible though?

Bob Phillips
10-30-2007, 07:43 AM
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.