Preventive Message

[Guest]

Hello

Could anyone tell me how can I create a message box which give users change to confirm Yes/No before proceed to a certain task/run a macro

Thanks

 

[Chip Pearson]

Try something like the following at the top of your macro.


If MsgBox("Continue?", vbYesNo) = vbNo Then
Exit Sub
End If



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Hello,

Could anyone tell me how can I create a message box which give

users change to confirm Yes/No before proceed to a certain
task/run a macro.

 

[Frank Kabel]

Hi
try something like

Sub foo()
Dim msbans
msbans = MsgBox("Do you want to continue?", vbYesNo)
If msbans = vbYes Then
'run your code
else
exit sub
End If
End Sub

--
Regards
Frank Kabel
Frankfurt, Germany

Hello,

Could anyone tell me how can I create a message box which give users

change to confirm Yes/No before proceed to a certain task/run a macro.