Message Box when click a button - help please

[jedibrown]

Good afternoon,

I was wondering how I would go about adding a "warning" or "message" box when somebody clicks my command button within my workbook please?

I basically want to give intructions in the box once the button is clicked then possibly a yes/no button for would you like to continue? If yes then the button runs, if no then it doesn't.

Any help would be gratefully received.

Thanks

x

 

[TiaXL]

Good afternoon,

I was wondering how I would go about adding a "warning" or "message" box when somebody clicks my command button within my workbook please?

I basically want to give intructions in the box once the button is clicked then possibly a yes/no button for would you like to continue? If yes then the button runs, if no then it doesn't.

Any help would be gratefully received.

Thanks

x

Dim Answer As String
Dim MyNote As String

Windows("blablabla.xls").Activate
Sheets("Sheet1").Select

MyNote = "Completed" & vbCrLf & "Send Emails Now?"

Answer = MsgBox(MyNote, vbQuestion + vbYesNo, "blabla")
If Answer = vbNo Then

Sheets("Sheet1").Select

ElseIf Answer = vbYes Then

Call somecode


End If
End Sub

 

[jedibrown]

Thanks for this - I ended up doing it the old fashioned way by adding a userform but you help is appreciated.

Thanks again