hi,

i wonder how to change the msgbox$B!!(B's$B!!(Bposition ,it always appears in the
middle of

screen, and the content of excel sheet will not be seen,

thanks

There is nothing built in. The easiest way is to make you own userform ,
then you can size/position as you want.

If you really want to use MsgBox, then
http://support.microsoft.com/?kbid=180936
Or Karl's class
http://vb.mvps.org/samples/project.asp?id=movedmsg

NickHK

"EXCEL$B!!(BNEWS" wrote in message
...
hi,

i wonder how to change the msgbox$B!!(B's$B!!(Bposition ,it always appears in the
middle of

screen, and the content of excel sheet will not be seen,

thanks