فى زر البحث ادخل الاكواد
Set sh12 = Sheets("QUOTATION BLOCKS & KERBS")
LR = sh12.[a2000].End(xlUp).Row
For Each cl In sh12.Range("a5:j" & LR)
If (Val(Me.TextBox19)) = cl Then
Me.TextBox1 = cl.Offset(0, 0)
Me.TextBox2 = cl.Offset(0, 1)
Me.TextBox3 = cl.Offset(0, 2)
Me.TextBox4 = cl.Offset(0, 3)
Me.TextBox5 = cl.Offset(0, 4)
Me.TextBox6 = cl.Offset(0, 5)
Me.TextBox7 = cl.Offset(0, 6)
Me.TextBox8 = cl.Offset(0, 7)
Me.TextBox9 = cl.Offset(0,
Me.TextBox10 = cl.Offset(0, 9)
Me.TextBox11 = cl.Offset(0, 10)
Me.TextBox12 = cl.Offset(0, 11)
Me.TextBox13 = cl.Offset(0, 12)
Me.TextBox14 = cl.Offset(0, 13)
Me.TextBox15 = cl.Offset(0, 14)
Me.TextBox16 = cl.Offset(0, 15)
Me.TextBox17 = cl.Offset(0, 16)
Me.TextBox18 = cl.Offset(0, 17)
End If
Next