Tom,
The data must be proceeded in a worksheet, so I use this:
Private Sub naam1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If Range("Werkblad!A12") < 3 Then
Dim Msg, Style, Title, Response
Msg = Range("error1").Value
Style = vbInformation
Title = Range("naam").Value
Response = MsgBox(Msg, Style, Title)
On Error Resume Next
Userform.naam1.SetFocus
End If
End Sub
You say, the exit can be canceled. What I made doesn't work
--
jgmidde
-----------------------------------------------------------------------
jgmiddel's Profile:
http://www.excelforum.com/member.php...fo&userid=3271
View this thread:
http://www.excelforum.com/showthread.php?threadid=52754