I know nothing about VBA except the recorder and able to modify a bit.
I have a macro to erase a form that is activated with a button. I would like
to be able to
have a message to confirm the deletion (Msgbox ) but have the choice to say
no and stop the macro from erasing.
I would appreciate any help please
Thanking you in advance
John

Try :
answ = MsgBox("Are you really sure ?", vbYesNo)
If answ = vbNo Then Exit Sub
' delete
Regards.
Daniel

> I know nothing about VBA except the recorder and able to modify a bit.
> I have a macro to erase a form that is activated with a button. I would like
> to be able to
> have a message to confirm the deletion (Msgbox ) but have the choice to say
> no and stop the macro from erasing.
> I would appreciate any help please
> Thanking you in advance
> John

Thank you Daniel
It works great
Have a nice day
John
"Daniel.C" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try :
> answ = MsgBox("Are you really sure ?", vbYesNo)
> If answ = vbNo Then Exit Sub
> ' delete
> Regards.
> Daniel
>
>> I know nothing about VBA except the recorder and able to modify a bit.
>> I have a macro to erase a form that is activated with a button. I would
>> like to be able to
>> have a message to confirm the deletion (Msgbox ) but have the choice to
>> say no and stop the macro from erasing.
>> I would appreciate any help please
>> Thanking you in advance
>> John
>
>

Thanks Charlotte
Works great
Regards
John
"Charlotte E." <@> wrote in message
news:(E-Mail Removed)...
>A one liner:
>
> If MsgBox("Do you want to delete?", vbYesNo + vbQuestion, "Confirm
> Delete") = vbNo Then Exit Sub
>
>
> CE
>
>
>
> John wrote:
>> I know nothing about VBA except the recorder and able to modify a bit.
>> I have a macro to erase a form that is activated with a button. I
>> would like to be able to
>> have a message to confirm the deletion (Msgbox ) but have the choice
>> to say no and stop the macro from erasing.
>> I would appreciate any help please
>> Thanking you in advance
>> John
>
>

Daniel;
Thanks very much for the code. It is working wonderfully!!!!!!

Kind regards.
Maperalia

"Daniel.C" wrote:

> Try :
> answ = MsgBox("Are you really sure ?", vbYesNo)
> If answ = vbNo Then Exit Sub
> ' delete
> Regards.
> Daniel
>
> > I know nothing about VBA except the recorder and able to modify a bit.
> > I have a macro to erase a form that is activated with a button. I would like
> > to be able to
> > have a message to confirm the deletion (Msgbox ) but have the choice to say
> > no and stop the macro from erasing.
> > I would appreciate any help please
> > Thanking you in advance
> > John
>
>
>