Hi,

just got a simple question, I'm trying to get the vbQuestion = vbYesNo to display however all i'm getting is the 'ok' button, any ideas what I'm doing wrong here? Thanks in advance

Private Sub CommandButton1_Click()

If TextBox1.Value = "" Or TextBox2.Value = "" Or TextBox3.Value = "" Then
    If MsgBox("Form is not complete. Do you want to continue?", vbQuestion = vbYesNo) <> vbYes Then
    Exit Sub
    End If
End If

ActiveCell = TextBox1.Value
ActiveCell.Offset(0, 1) = TextBox2.Value
ActiveCell.Offset(0, 2) = TextBox3.Value

ActiveCell.Offset(1, 0).Select

Call resetForm


End Sub