1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| Private Sub TextBox3_AfterUpdate()
On Error GoTo 1
If WorksheetFunction.CountIf(Sheets("STOCK").Range("B:B"), Me.TextBox3.Value) = 0 Then
MsgBox "NOT EXIST", vbInformation + VBORONLY, "NON TROUVE"
End If
With Me
.TextBox2 = Application.WorksheetFunction.VLookup((Me.TextBox3), Sheets("stock").Range("data2"), 2, False)
.TextBox4 = Application.WorksheetFunction.VLookup((Me.TextBox3), Sheets("stock").Range("data2"), 3, False)
.TextBox5 = Application.WorksheetFunction.VLookup((Me.TextBox3), Sheets("stock").Range("data2"), 6, False)
.TextBox6 = Application.WorksheetFunction.VLookup((Me.TextBox3), Sheets("stock").Range("data2"), 11, False)
.TextBox8 = Application.WorksheetFunction.VLookup((Me.TextBox3), Sheets("stock").Range("data2"), 9, False)
.TextBox7 = Application.WorksheetFunction.VLookup((Me.TextBox3), Sheets("stock").Range("data2"), 5, False)
End With
1
End Sub |
Partager