I have 4 questions, van you help?

Originally Posted by jimmisavage

brilliant thanks sooooo much.

ok, i'm gunna sound a bit stupid now so please forgive me.

I only need the button for 1 page, but i really dont know how to put a button in, use design mode or very much about macro. To be honest i never even used excel untill about 2 months ago.

i dont mind learning myself if you want to piont me in the right direction. or, if you dont mind, can you tell me how to use design mode? and how i would put my button in, and make it clear these cells of mine?

ok - select

View, Toolbars and tick the Control Toolbox

first icon there toggles Design Mode, select design mode

select a button and draw a shape on the sheet

rightmouse the shape and 'Properties'

amend Caption

amend Backcolor, dropdown, Palette and select the top (light) Blue

x that window to close

rightmouse the button and select View Code

in there put

  Dim iResponce As Integer
    iResponce = MsgBox("Are you sure you want to delete?", vbYesNo, "Confirm Delete")
    If iResponce = vbYes Then
        MsgBox "y"
    Else
        MsgBox "n"
    End If

exit design mode, and then test the button

Let us know how you go.

---

added, also make sure you use VBA Noob's amended code, but change Sheets(1).Select to Sheets("Front Page").Select if the front page is not the tab on the extreme left.