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

[µo°Ý] (¤w¸Ñ¨M)µù¸Ñªº¦ì¸m¦³¿ìªk§Ö³t²¾¦^¬Û¹ïÀ³ªºÀx¦s®æ¶Ü

[µo°Ý] (¤w¸Ñ¨M)µù¸Ñªº¦ì¸m¦³¿ìªk§Ö³t²¾¦^¬Û¹ïÀ³ªºÀx¦s®æ¶Ü

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-4-16 08:48 ½s¿è

¦b°µ¸ê®Æ®É¤£¤p¤ß±Nµù¸Ñ©ÔÂ÷Àx¦s®æ«Ü»·ªº¦a¤è(¦Û°Ê¿z¿ï®É§@§¹µù¸Ñ§Ñ¤F±Nµù¸ÑÁôÂáA­n§äªº®É­Ô´N·|Â÷«Ü»·)
ºCºC©Ô¦n¹³¦³ÂI¤£²Å¦X¸gÀٮįq
¤£ª¾¹D¦³¨S¦³¦nªº¤è¦¡?
§Ú­nÅýµù¸Ñ³B©óÅã¥Üª¬ºA
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

­è­èµo²{¤@­Ó¤è¦¡
¤£ª¾¹D³oºâ¤£ºâ¦n¤èªk
²Ä1¦U¤u§@ªí¥Üµo¥Íªºª¬ªp
²Ä2¦U´N¬O§Úªº°ÝÃD
µ¥§Ú²¾§¹§Úµo²{¥i¥H¥Î­áµ²µ¡®æªº¤è¦¡
´N¬O²Ä3~²Ä4¦U
¤£ª¾¹D³oºâ¤£ºâ¦n¤èªk?


·s¼WMicrosoft Excel ¤u§@ªí.rar (3.93 KB)
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦b(®Õ¾\)¦³¤@­Ó(Åã¥Ü©Ò¦³µù¸Ñ)
sky

TOP

  1. Sub Macro1()
  2. For Each c In Cells.SpecialCells(xlCellTypeComments)
  3. c.Comment.Shape.Placement = 1
  4.          c.Comment.Shape.Top = c.Top
  5.          c.Comment.Shape.TextFrame.AutoSize = True
  6.     Next
  7. End Sub
½Æ»s¥N½X

TOP

¦^´_ 5# oobird


   ÁÂÁª©¥D
  ¸Õ¹L¥i¥H
  ¦Û¤v¦³¿ý¹L¥¨¶°¦ý¬O§ä¤£¨ì¤@­Ó¤èªk
  ³oºØ¤è¦¡¬O³Ì§Öªº
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

§äµª®×§ä¨Ó³oÃä¡A¯u¬O¤Ó¤è«K¤F¡A¤£¹L­n¥ý¨ú®ø¦X¨ÖÀx¦s®æ¤~¯à¶¶§Q°õ¦æ~µ¹¤£¼ô±x¥¨¶°ªº¤H°Ñ¦Ò¡A¤£­n¥H¬°¤£¯à¥Î
Adam

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD