Clear textbox in textbox_change event

[Otchoo]

Hi,

I have a question about a textbox1_change event.

I created an event that when a number is pasted in a textbox, it will lookup the number in a sheet.

But how do i clear the textbox at the end of the event without triggering the event immediately.

Because if i use this code at the end of the private_sub:

Userform1.Textbox1.value = ""

The textbox will go into a infinite loop.

So what i basically want is that paste value in one textbox on a userform.
The routine runs
And clears the textbox at the end of the Routine so i can paste the next value in the textbox

 

[dmt32]

Hi,
welcome to forum

Try adding following line at the Top of the change event & see if resolves your issue

Private Sub TextBox1_Change()
    If Len(Me.TextBox1.Value) = 0 Then Exit Sub

   'rest of code


End Sub

Dave

 

[Saurabhj]

Hi, please check if below line at the top with in the routine helps.

Private Sub TextBox1_Change()
If Len(Trim(TextBox1.Text)) = 0 Then Exit Sub
'your code is here...
End Sub