User Form TextBox Events

Hi folks,

I need some advice on coding a Textbox event.

I have a UserForm that utilizes the Change event of a Textbox.

The form goes through some validating before any calculations happen.

My problem is if the user wishes to backspace, clear or perform any changes to this textbox, it bugs out.

Here's the code:

'Validate that all the necessary data is entered before running sub
Private Sub ComboBox1_Change()

    If TextBox1.Value <> "" And ComboBox2.Value <> "" Then
    Call ConvertCalc1
    Else: Exit Sub
    
    End If
    
End Sub

'Validate that all the necessary data is entered before running sub
Private Sub ComboBox2_Change()

    If TextBox1.Value <> "" And ComboBox1.Value <> "" Then
     Call ConvertCalc1
    Else: Exit Sub
    
    End If
    
End Sub

'Validate that all the necessary data is entered before running sub
Private Sub TextBox1_Change()

    
    If ComboBox1.Value <> "" And ComboBox2.Value <> "" Then
     Call ConvertCalc1
    Else: Exit Sub
    End If
    
End Sub

I'm sure it's easy to fix but I've painted myself into a corner on this one.

I've included the file for reference

Thanks!

Mark