ABOUT MSGBOX

[Guest]

How do I change the msgbox position? The default is placed in the center, I
want the msgbox opened where I expected.....in right, left, right corner or
left corner.
Thanks in advance!

 

[Norman Jones]

Hi Andy,

See the following post by Tom Ogilvy reporting Jim Rech's suggestion:

http://tinyurl.com/drnvu

 

[Guest]

Hi Norman,

I have copy the code and found below compile error message :

"Constants, fixed-length strings, arrays, user-defined types, and Declare
statements not allowed as Public members of an object module"

Public Const GWL_HINSTANCE = (-6)
Public Const SWP_NOSIZE = &H1
Public Const SWP_NOZORDER = &H4
Public Const SWP_NOACTIVATE = &H10
Public Const HCBT_ACTIVATE = 5
Public Const WH_CBT = 5

Could you please advise? Thanks very much!

 

[Dave Peterson]

Try pasting that code into a General module--not behind a worksheet,
ThisWorkbook, a class module or a userform.