Message box & close worksheet
Many thanks to Mike, Papou, Nick, Snake and Incedental. Job done
Snake, "I heard you were dead" Much better now, I see.lol
--
tia
Jock
"Jock" wrote:
Code bolow doesn't close the worksheet when 'no' is chosen rather than yes.
Any ideas?
Private Sub CommandButton1_Click()
MsgBox("Do you wish to order another item?", _
vbYesNo)
If response = vbYes Then
If vbYes Then
TextBox3.SetFocus
Else
ThisWorkbook.Close True
End If
End If
End Sub
--
tia
Jock
|