½Ð¯q,
¦b«ü©wªºÄæ¦ì B3:B7 ¨Ï¥Î¤U©Ô¿ï³æ¥i§¹¦¨±ø¥óIJµo±a¤J¥H¤Uªº i Ȩì¤u¥óªí¡A
¦ý¬O¦pªG¨Ï¥ÎKeyin¤è¦¡«hµLªk±a¤J i È¡D
B3:B7 ¦³¨Ï¥Î¸ê®ÆÅçÃÒ¡Aªþ¤Wsample ¡A·Ð½Ð¥ý¶i´£ÂI¡D·PÁÂ
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B3:B7")) Is Nothing Then
i = Worksheets("Defect Code").[A:A].Find(ActiveCell.Value).Offset(, 1).Resize(, 2)
Range(Target.Address).Offset(, 1).Resize(, 2) = i
End If
End Sub |