View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James Montgomery James Montgomery is offline
external usenet poster
 
Posts: 17
Default MsgBox Screen Position

Hi,
Can you control the displayed position of the following MsgBox and a more
simple one below that
Thanks,
James

(Message Box 1)
Dim Msg, Style, Title, Response
Msg = "Do you want to copy this file" & Chr(13) & Chr(13) & _
"Choose ""YES"" to proceed." & Chr(13) & _
"Choose ""NO"" to cancel & quit"
Style = vbYesNo + vbInformation + vbDefaultButton1
Title = "Export"

Response = MsgBox(Msg, Style, Title)
If Response = vbYes Then
Else
If Response = vbNo Then Exit Sub
End If

(Message Box 2)
MsgBox Title:=("Error "), prompt:= "Sorry"