script VBA untuk VlookUp
misal saat ketik kode 35-210 mak akan muncul kode dan Description lainya
Private Sub TKODE_Exit(ByVal Cancel As MSForms.ReturnBoolean)
CM = Me.TKODE.Value
Set WS = Sheet3
With WS.Range("MASTERDATA")
Set CM = .Find(CM, LookIn:=xlValues)
If Not CM Is Nothing Then
Baris = CM.Row
Me.TMATERIAL.Value = WS.Cells(Baris, 2).Value
Me.TNAMASAP.Value = WS.Cells(Baris, 3).Value
End If
End With
End Sub
CM = Me.TKODE.Value
Set WS = Sheet3
With WS.Range("MASTERDATA")
Set CM = .Find(CM, LookIn:=xlValues)
If Not CM Is Nothing Then
Baris = CM.Row
Me.TMATERIAL.Value = WS.Cells(Baris, 2).Value
Me.TNAMASAP.Value = WS.Cells(Baris, 3).Value
End If
End With
End Sub

0 comments:
Post a Comment
Silahkan Untuk komentarnya