help with select case statement

[kelly mort]

I have this code section used to confirm a delete. But when even I click No, it still deletes the entry. What is that I am doing wrongly? I don’t seem to figure it out yet. Please help a friend. Thanks
Kelly

Select Case MsgBox("You are about to delete ID " & Reg1.Value & vbCrLf & "Do you want to proceed?", vbYesNo Or vbQuestion Or vbDefaultButton1, "Are you sure about this?")
        Case vbYes
        Case vbNo
    End Select

 

[Michael M]

You don't need a select case to do this

Sub MM1()
msg=MsgBox ("You are about to delete ID " & Reg1.Value & vbCrLf & "Do you want to proceed?")
If msg=vbNo Then Exit Sub
End Sub

 

[kelly mort]

Thanks for the tip. I appreciate it. The point is i was tired and just got too confused.

 

[Michael M]

i was tired and just got too confused.

Happens to all of use...

 

[kelly mort]

Haha