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

Excel µù¸Ñªº°ÝÃD

¦^´_ 1# mukila
  1. Sub nn()
  2. With Range("A1")
  3. If .Comment Is Nothing Then
  4.    .AddComment Text:=CStr([B1] + [C1])
  5.    Else
  6.    .Comment.Text CStr([B1] + [C1])
  7. End If
  8. .Comment.Visible = False
  9. End With
  10. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD