ABOUT MSGBOX

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 Andy,

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

http://tinyurl.com/drnvu

---
Regards,
Norman



"Andy" <Andy@discussions.microsoft.com> wrote in message
news:51B1C982-E362-4F83-B82F-B8FD359146F1@microsoft.com...
> 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!

"Norman Jones" wrote:

> Hi Andy,
>
> See the following post by Tom Ogilvy reporting Jim Rech's suggestion:
>
> http://tinyurl.com/drnvu
>
> ---
> Regards,
> Norman
>
>
>
> "Andy" <Andy@discussions.microsoft.com> wrote in message
> news:51B1C982-E362-4F83-B82F-B8FD359146F1@microsoft.com...
> > 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!
>
>
>

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



Andy wrote:
>
> 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!
>
> "Norman Jones" wrote:
>
> > Hi Andy,
> >
> > See the following post by Tom Ogilvy reporting Jim Rech's suggestion:
> >
> > http://tinyurl.com/drnvu
> >
> > ---
> > Regards,
> > Norman
> >
> >
> >
> > "Andy" <Andy@discussions.microsoft.com> wrote in message
> > news:51B1C982-E362-4F83-B82F-B8FD359146F1@microsoft.com...
> > > 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!
> >
> >
> >

--

Dave Peterson