PDA

View Full Version : How to make all MsgBox and InputBox pop up in the same part of the screen.



hugh1994
05-19-2014, 02:19 AM
Hello.

At the moment I have InputBox, MsgBox and Application.InputBox(Type=1) functions, however when running through the macro the Application.InputBox pops up in a different part to its error window and also the other InputBox and MsgBox functions.

So how do I get them to all, say, pop up with their left hand corner at Cell H3.

Thank you.

Bob Phillips
05-19-2014, 02:23 AM
Why does it matter? As long as it can be seen surely no-one will care?

EirikDaude
05-19-2014, 03:07 AM
Some quick googling gave me this: http://social.msdn.microsoft.com/Forums/en-US/c5360549-a068-4199-a178-970ff4247cf8/msgbox-size-and-position

Though it seems to be more trouble than it's worth, if you ask me :P

Paul_Hossler
05-19-2014, 05:24 AM
Hello.

At the moment I have InputBox, MsgBox and Application.InputBox(Type=1) functions, however when running through the macro the Application.InputBox pops up in a different part to its error window and also the other InputBox and MsgBox functions.

So how do I get them to all, say, pop up with their left hand corner at Cell H3.

Thank you.

The 3 built in functions might be cosmetically unaesthetic, but it were important enough, you could see if using a User Form to combine the 3 functions would work. At least it would be in the same position each time

mikerickson
05-19-2014, 06:23 PM
InputBox and Application.InputBox have Left and Top arguments that can be used to position them.