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
Bookmarks