Code for Pop-up Message Box with Confirmation

**macky1730** · 04-13-2009, 04:28 AM

Guys, what code to use for integrating to commandbutton for showing a pop-up message box with confirmation of "yes" or "no" buttons?

i would like to put a commandbutton on activesheet, if i press the button a message box will appear ex. "do you realy want to delete cell?" then the selection below will be visible ex. "yes" or "no".. thanks again

**JBeaucaire** · 04-13-2009, 05:20 AM

Something like this:

If MsgBox(("Do you really wish to delete this cell?"), vbYesNo + vbQuestion + vbDefaultButton2, _
                "Confirmation Required:") = vbYes Then ActiveCell.ClearContents

**macky1730** · 04-13-2009, 07:24 AM

thanks again

**royUK** · 04-13-2009, 07:31 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save