Confirmation code help

[Veeru106]

Hi,


I need help on small thing…I have a confirmation code.


Which just popup to user for asking whether they are sure to submit data or not.


If they click on sure , it will trigger another mail.


But if they click on cancel it gives me error code, so I want something to add , if they click on cancel…nothing should happened.


After” Then Call ICA”, what should we add ??


Sure = MsgBox("Are you sure to Submit numbers?", vbOKCancel)

If Sure = 1 Then Call ICA


End sub

 

[Belleke]

This?

If Sure = 0 Then Exit Sub

 

[vletm]

Veeru106
As with Your file ...
Click [ Submit Numbers ]-button ...

 

[Veeru106]

Thank Belleke and vletm....you always come to my rescue...