Hello everyone,
I'm new in VBA and want to know how to look for results in another worksheet than the actual one. Actually, i have a textbox to research result but in the same sheet. Do you know how to do it?
Thank you for your help!
I'm new in VBA and want to know how to look for results in another worksheet than the actual one. Actually, i have a textbox to research result but in the same sheet. Do you know how to do it?
Thank you for your help!
Private Sub TextBox1_Change() Application.ScreenUpdating = False Range("B46:B70").Interior.ColorIndex = 2 ListBox1.Clear If TextBox1 <> "" Then For ligne = 46 To 70 If Cells(ligne, 2) Like "*" & TextBox1 & "*" Then Cells(ligne, 2).Interior.ColorIndex = 43 txt = Cells(ligne, 2) ListBox1.AddItem txt End If Next End If End Sub |