Private Sub TextBox1_Change() With TextBox1 If Len(.Value) > 0 Then If Len(.Value) - Len(Int(.Value)) > 5 Then .Value = WorksheetFunction.RoundDown(.Value, 4) End If End If End With End Sub
Private Sub TextBox1_Change() With TextBox1 If Len(.Value) > 0 Then If Len(.Value) - Len(Int(.Value)) > 5 Then .Value = WorksheetFunction.RoundDown(.Value, 4) End If End If End With End Sub