VBA - Look for range in another sheets

[van0912]

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!

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

 

[davesexcel]

You would place the sheet name in front of the range

sheets("Sheet2").Cells(ligne, 2)

 

[van0912]

You would place the sheet name in front of the range

sheets("Sheet2").Cells(ligne, 2)

Oh yes, it works! Thanks a lot!!