ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦p¦ó¨Ì¦WºÙ§@¬°·j´M±ø¥ó«á©¹¥k¤@Äæ¨ÃÅã¥Ü¦bª`¸Ñ

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim xF As Range
With Target.Item(1)
¡@¡@¡@If .Column <> 3 Then Exit Sub
¡@¡@¡@Cancel = True
¡@¡@¡@If Not .Comment Is Nothing Then .ClearComments: Exit Sub
¡@¡@¡@If .Value = "" Then Exit Sub
¡@¡@¡@Set xF = Sheets("µæ³æ(¤Å°Ê)").[B:B].Find(.Value, Lookat:=xlWhole)
¡@¡@¡@If xF Is Nothing Then Exit Sub
¡@¡@¡@.NoteText xF & Chr(10) & xF(1, 2).Text
¡@¡@¡@.Comment.Visible = True
End With
End Sub

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD