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

°õ¦æ¥¨¶°«ü¥O®É«ö¶s«o¤@ª½¼W¥[(²Ä¤G¦¸µo°Ý)

°õ¦æ¥¨¶°«ü¥O®É«ö¶s«o¤@ª½¼W¥[

½Ð°Ý¡K
§Ú¥ÎªºEXCEL¬O2010ª©ªº.
§Ú¦b¤@­Ó¤u§@ªí¤¤¡A¦³¥|­Ó«ö¶s(ªí³æ±±¨î¶µ)¡A
§Ú¿ý»s¤F¤@­Ó¥¨¶°¡A±N³o¤u§@ªí¾ã­Ó½Æ»s¨ì¤@­Ó·sªºÀɮסA
©_©Çªº¬Oªí®æ¤¤ªº¸ê®Æ¤º®e³£¨S¦³°ÝÃD¡A¦ý¬O³o¥|­Ó«ö¶s«o³Q·sªº«ö¶sµ¹Âл\¦í¤F¡F¤]´N¬O»¡¦b­ì¨Ó«ö¶sªº¦a¤è¡A²£¥Í¤F·sªº«ö¶s»\¦b¤W­±¡A«ö¶s¦WºÙ«h¬°¡¨«ö¶s1¡¨©Î¡¨«ö¶s2¡¨µ¥¡A¥u­n¦A°õ¦æ¤@¦¸³o¥¨¶°¡A´N·|¦A²£¥Í·sªº«ö¶s¡A¨C¦¸²£¥Í¥|­Ó¡A¦]¬°§Ú­ì¥»´N¦³¥|­Ó«ö¶s¡C
ÁÙ¦³§ó©_©Çªº¬O¡A­ì¨ÓªºÀɮפ]¤@¼Ë²£¥Í¤F¦P¼Ëªº«ö¶s¡A¦Ó¥B¤@ª½¥[¤W¥h¡F¤]´N¬O¨C°õ¦æ¤@¦¸´N·|³QÂл\¤@¦¸¡C
¥H«e¨S¦³³o²{¶H¡A³o¬O¬°¤°»ò©O?
³oÀ³¸Ó¬O©M¨t²Î±qWIN 7´«¦¨WIN8.1¨S¦³Ãö«Y§a?¦]¬°³Ìªñ´«¤F·sªº¹q¸£¡C
½Ð¦U¦ì¹F¤H¸Ñ´b¤F,ÁÂÁÂ.

TOP

¦^´_ 1# blueskyneter


    ·|¤£·|¬O«ö¶s¬O©ñ¦b½Æ»sªºÀx¦s®æªº½d³ò¤º ,©Ò¥H³s±a¤@°_½Æ»s¤@¥÷¤F

TOP

¦^´_ 2# starry1314


    ¤j¤j§ÚÀ°§A´ú¸Õ¤F¤@¤U, §Ú¥Î¤â°Ê½Æ»s¶K¤W, ¦n¹³¤£·|¦Û¤v½Æ»s«ö¶s

TOP

ÁÂÁ¼ӤW¨â¦ìªº¦^ÂÐ:
TO¦B¼Ü¡G±z»¡ªº§Ú¤]·Q¹L¡A¥i¬O§Ú¥ý±N¨º¨Ç­ì¥»ªº«ö¶sµ¹¥ý§R°£±¼¡A¦A¨Ó¿ý»s¥¨¶°¤§«á¦A¨Ó°õ¦æ³o¥¨¶°¡Aµ²ªGÁÙ¬O¤@¼Ë¡A¦b·sªºÀɮפ¤·|²£¥Í¥|­Ó·sªº«ö¶s¤§¥~¡A­ì¥»ªº­ì©lÀɤ]¤@¼Ë¤S¦A²£¥Í¤@¼Ëªº«ö¶s°Ú¡C

TO jackyq¡G±z»¡ªº¨S¦³¿ù¡A¤â°Êªº¸Ü¬O³£«Ü¥¿±`¡F¨Ò¦p²Ä¤@¦¸¦b¿ý»s¥¨¶°®É¤]¤@¼Ë¨S¦³°ÝÃD¡A¥i¬O°õ¦æ¥¨¶°ªº¸Ü´N¥X²{¤F³o°ÝÃD¡C©Ò¥H¤~¦bÀYµh¤£©ú¥Õ­ì¦]¥X¨Ó­þùØ¡C

¤£ª¾¹DÁÙ¦³¤°»ò¥i¯à©Ê¡H

TOP

¦^´_ 4# blueskyneter


    ¨S code ¨S answer

TOP

¶â¡D¡D§Ú¨Ó¬ã¨s¤@¤U¬ÝÀ³¦p¦ó¨Ó¤W¶ÇÀɮצA½Ð¦U¦ì°ª¤âÀ°¦£¡D¡D
ÁÂÁ¡D

TOP

°õ¦æ¥¨¶°«ü¥O®É«ö¶s«o¤@ª½¼W¥[(²Ä¤G¦¸µo°Ý)

[ª©¥DºÞ²z¯d¨¥]
  • GBKEE(2015/7/7 05:25): ªþÀɦ³¨p¤H¸ê®Æ,½Ð­×§ï¦A¤W¶Ç,¥ý´À§A§RÀÉ.

¥»©«³Ì«á¥Ñ GBKEE ©ó 2015-7-7 05:26 ½s¿è

¹ê¦b¬O¤£ª¾¹D¦p¦ó¦b¤§«eªº°ÝÃD¤¤´¡¤J³o°ÝÃDÀÉ¡A¥u¦n¦A­«¶}¤@­Óµo°Ýªº°ÝÃD¡A½Ð¦U¦ì¨£½Ì¡C
³o¦³°ÝÃDªº¬O¦b³oªþÀɮפ¤"²î­ûÁ~¸ê½Ð´Ú³æ (§t²Ä¤@¦¸¥Î¶O))"³o¤u§@ªí¤§¤¤¡C
°õ¦æ¤F"¥t¦s½Ð´Ú³æ"ªº«ö¶s´N¥X²{¤F¥H¤Uªº°ÝÃD¡C


°õ¦æ¥¨¶°«ü¥O®É«ö¶s«o¤@ª½¼W¥[

½Ð°Ý¡K
§Ú¥ÎªºEXCEL¬O2010ª©ªº.
§Ú¦b¤@­Ó¤u§@ªí¤¤¡A¦³¥|­Ó«ö¶s(ªí³æ±±¨î¶µ)¡A
§Ú¿ý»s¤F¤@­Ó¥¨¶°¡A±N³o¤u§@ªí¾ã­Ó½Æ»s¨ì¤@­Ó·sªºÀɮסA
©_©Çªº¬Oªí®æ¤¤ªº¸ê®Æ¤º®e³£¨S¦³°ÝÃD¡A¦ý¬O³o¥|­Ó«ö¶s«o³Q·sªº«ö¶sµ¹Âл\¦í¤F¡F¤]´N¬O»¡¦b­ì¨Ó«ö¶sªº¦a¤è¡A²£¥Í¤F·sªº«ö¶s»\¦b¤W­±¡A«ö¶s¦WºÙ«h¬°¡¨«ö¶s1¡¨©Î¡¨«ö¶s2¡¨µ¥¡A¥u­n¦A°õ¦æ¤@¦¸³o¥¨¶°¡A´N·|¦A²£¥Í·sªº«ö¶s¡A¨C¦¸²£¥Í¥|­Ó¡A¦]¬°§Ú­ì¥»´N¦³¥|­Ó«ö¶s¡C
ÁÙ¦³§ó©_©Çªº¬O¡A­ì¨ÓªºÀɮפ]¤@¼Ë²£¥Í¤F¦P¼Ëªº«ö¶s¡A¦Ó¥B¤@ª½¥[¤W¥h¡F¤]´N¬O¨C°õ¦æ¤@¦¸´N·|³QÂл\¤@¦¸¡C
¥H«e¨S¦³³o²{¶H¡A³o¬O¬°¤°»ò©O?
³oÀ³¸Ó¬O©M¨t²Î±qWIN 7´«¦¨WIN8.1¨S¦³Ãö«Y§a?¦]¬°³Ìªñ´«¤F·sªº¹q¸£¡C
½Ð¦U¦ì¹F¤H¸Ñ´b¤F,ÁÂÁÂ.

¦]¬°§ä¤£¨ì¦p¦ó´¡¤J½d¨Òªº¤èªk¡A¥u¦n¦A¶}±Ò¥t¤@­Óµo°Ýªº°ÝÃD..
Àµ½Ð¦U¦ì¹F¤HÀ°¦£,ÁÂÁ¡C

TOP

¦^´_ 8# blueskyneter

§A«ü©wªº¬O¥¨¶°10¸Ì­±ªº¦×®e´N¬O¼W¥[«ö¶s°Ú¡I¬O¤£¬O«ü©w¿ù¤F¡I
  1. Sub ¥¨¶°10()
  2. '
  3. ' ¥¨¶°10 ¥¨¶°
  4. '

  5. '
  6.     Sheets("²î­ûÁ~¸ê½Ð´Ú³æ (§t²Ä¤@¦¸¥Î¶O))").Select
  7.     ActiveSheet.Buttons.Add(579.75, 19.5, 66.75, 42).Select
  8.     ActiveSheet.Buttons.Add(581.25, 64.5, 64.5, 32.25).Select
  9.     ActiveSheet.Buttons.Add(507.75, 29.25, 52.5, 24).Select
  10.     ActiveSheet.Buttons.Add(51, 4.5, 70.5, 16.5).Select
  11.     ActiveSheet.Buttons.Add(509.25, 67.5, 54, 21).Select
  12.     Sheets("²î­ûÁ~¸ê½Ð´Ú³æ (§t²Ä¤@¦¸¥Î¶O))").Copy
  13. End Sub
½Æ»s¥N½X

TOP

Sub ¥¨¶°10()
'
' ¥¨¶°10 ¥¨¶°
'

'
    Sheets("²î­ûÁ~¸ê½Ð´Ú³æ (§t²Ä¤@¦¸¥Î¶O))").Select
'    ActiveSheet.Buttons.Add(579.75, 19.5, 66.75, 42).Select   '.......................®³±¼
'    ActiveSheet.Buttons.Add(581.25, 64.5, 64.5, 32.25).Select   '.......................®³±¼
'    ActiveSheet.Buttons.Add(507.75, 29.25, 52.5, 24).Select   '.......................®³±¼
'    ActiveSheet.Buttons.Add(51, 4.5, 70.5, 16.5).Select   '.......................®³±¼
'    ActiveSheet.Buttons.Add(509.25, 67.5, 54, 21).Select   '.......................®³±¼
    Sheets("²î­ûÁ~¸ê½Ð´Ú³æ (§t²Ä¤@¦¸¥Î¶O))").Copy
End Sub

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD