ABOUT MSGBOX

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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!
 
Try pasting that code into a General module--not behind a worksheet,
ThisWorkbook, a class module or a userform.
 
Back
Top