½Ð¤j®aÀ°§Ú¬Ý¤@¤U¥¨¶°µ{¦¡¦p¦ó§ï
Private Sub Worksheet_Change(ByVal Target As Range)
Dim xf As Range
Application.EnableEvents = False
If Target(1).Address(0, 0) = "B4" Then
If Target(1) = "" Then
Range("B3") = ""
Else
Set xf = [¤¤¤å©m¦W].Find(Target(1), lookat:=xlWhole)
Range("B3") = xf.Offset(, -1)
End If
End If
Application.EnableEvents = True
End Sub |