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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.