Stop exit event of textbox firing when click a command button to close a userform

The problem is that when you try to click the button, the Exit event on the textbox takes precedence and you never get the button Click event. So the textbox complains that it's still blank.

I can think of very few cases where you want to use an Exit event to force the user to provide a value. I would redesign the user interface so that you are not checking the content of the textbox until you try to exit the form. Then check for an empty textbox at that point.

I guess this could solve your problem:

Dim bflag As Boolean
Private Sub cmdClearAndExit_Click()
    If bflag Then
        Unload Me
    End If
End Sub
Private Sub supplierpricetxt_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    If Not bflag Then
        bflag = False
        If supplierpricetxt = "" Then
            Ans = MsgBox("No Batch No entered." & vbCrLf & "Click Cancel to return to BatchNo" & vbCrLf & "Click OK to exit without BatchNo", vbOKCancel)
            Select Case Ans
                Case 2 'Cancel clicked
                    Cancel = True
                Case 1 'OK clicked
                    bflag = True
                    cmdClearAndExit_Click
            End Select
        End If
    End If
End Sub

And yes, you shouldn't use the exit-event for validation purposes. Consider the before_update or after_update events.