Message box & close worksheet
hi Jock
You could do like this
Private Sub CommandButton1_Click()
Response = MsgBox("Do you wish to order another item?", vbYesNo)
If Response = vbYes Then
TextBox3.SetFocus
Else
ThisWorkbook.Close
End If
End Sub
hope it helps
S
|