msg box question

[jerryjaysr]

Lost it...had it written down but lost the directions...aghhhh

Anyone?

Also, Can I add a way so if I run a macro and the msg box pops up before the pops up when done, is there a way I can select yes to complete the macro or no to shut it down.
Its important that I write a macro to delete a bunch of cells, but if the user does it by mystake - alot going on in that page - I would like a way to confirm the deletion - like yes to proceed or no to cancel. The macro just deletes some cells (but alot that the user may have already inputted) and the pages are protected but those cells.

Helping a friend working on a project and these are about the last of things I have left. The file is big now - about 15-20 meg. Is there a place here where I can upload the final project for a viewing or anyone like to look at it. Of course you would be able to use it when all completed.

[Leith Ross]

Hello jerryjaysr,

I can answer you about adding the Yes No buttons to a message box. See the Example below...

Dim Answer As Variant
Dim Msg As String
  Msg = "Do you wish to exit the macro?"
    Answer = MsgBox Msb, vbYesNo+vbDefaultButton2
      If Answer = vbYes Then Exit Sub

"No" is the default button. If you want the "Yes" button use vbDefaultButton1 constant instead of vbDefaultButton2.

Sincerely.
Leith Ross

[jerryjaysr]

NOt sure if I am doing it right. Made a quick object box, created a macro,
inserted the lines exactly from above and get syntax error when I run it on
Answer = MsgBox Msb, vbYesNo+vbDefaultButton2

[jindon]

a typo

Msb -> Msg

[jerryjaysr]

now have:
Answer = MsgBox Msg, vbYesNo+vbDefaultButton1

and still get compile error: end of statement

?????

Macro has exactly what LR wrote with the switch of msg and still does not work

[jindon]

Answer = MsgBox(Msg, vbYesNo+vbDefaultButton1)