bradpallister
New Member
Hi
I have the following code:
'Sub RequisitionCompleteMsgBox()
MyVar = MsgBox(Prompt:="Thank you. You have saved your Requisition successfully. You can now close this workbook without saving further.", _
Buttons:=vbInformation, Title:="Requisition Submitted!")
MsgBox MyVar
End Sub
Does anyone know why when the Information comes up and is clicked OK etc, another MsgBox comes up, a number "1" is displayed with a OK button.
I don't want this extra MsgBox at all. Any ideas how to get rid of it??
Thanks v m
bradpallister
I have the following code:
'Sub RequisitionCompleteMsgBox()
MyVar = MsgBox(Prompt:="Thank you. You have saved your Requisition successfully. You can now close this workbook without saving further.", _
Buttons:=vbInformation, Title:="Requisition Submitted!")
MsgBox MyVar
End Sub
Does anyone know why when the Information comes up and is clicked OK etc, another MsgBox comes up, a number "1" is displayed with a OK button.
I don't want this extra MsgBox at all. Any ideas how to get rid of it??
Thanks v m
bradpallister