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

[µo°Ý] (¤w¸Ñµª¡AG¤jÁÂÁÂ)¦p¦óÅý¦Û­qªí³æÃö³¬«á¼È¦s¡A¶}±Ò«áÄ~Äò§@·~¡H

[µo°Ý] (¤w¸Ñµª¡AG¤jÁÂÁÂ)¦p¦óÅý¦Û­qªí³æÃö³¬«á¼È¦s¡A¶}±Ò«áÄ~Äò§@·~¡H

¥»©«³Ì«á¥Ñ av8d ©ó 2012-6-14 16:20 ½s¿è

¤@¯ë¦Û­qªí³æÃö³¬«á~­«·s¶}±Ò~¸ê®Æ³£·|®ø¥¢~
¦p¦óÅý¥L¥i¥H¼È¦s~¸Ó¦p¦ó¼g?

¦^´_ 1# av8d
ªí³æ.Hide   
Hide ¤èªk   ÁôÂä@­Óª«¥ó¦ý¤£¸ü¥X¡C

TOP

¦^´_ 2# GBKEE


  G¤j±z¦n
  ¦pªG§Ú·Q­n§Úªºªí³æ¥H¤Îªí³æ¤ºªº«ö¶s¡BªºPicture¹Ï¡A¦bExcelÃö³¬«á¦A¶}±Ò¡A©Ò¦³ªºPicture¹Ï³£ÁÙ¦b
  ½Ð°Ý­n¦p¦ó¸Ñ¨M?

TOP

¦^´_ 3# dafa
Picture ¶·¬O¤w¦sÀÉ
¬O³o¼Ë¶Ü?
  1. 'Initialize ¨Æ¥ó µo¥Í¦b¤@­Óª«¥ó¸ü¤J«á¡A¦ý©|¥¼Åã¥Üªº®É­Ô¡C
  2. Private Sub UserForm_Initialize()   'UserFormªº¹w³]¨Æ¥ó
  3.     UserForm1.Picture = LoadPicture("D:\EX1.GIF")
  4.     CommandButton1.Picture = LoadPicture("D:\EX2.GIF")
  5.     'CommandButton2.Picture = LoadPicture("D:\EX3.GIF")
  6.     'CommandButton3.Picture = LoadPicture("D:\EX4.GIF")
  7. End Sub
½Æ»s¥N½X

TOP

¦^´_ 4# GBKEE


    G¤j§Ú¤]¬O¥Î³o­Ó¤èªk
   ¦ýÁÙ¬O¤£¦æªþ¤W§Ú«÷¸ËªºÀɮ׬ݦ³¨S¦³¨ä¥Lªº¤èªk
   ³Â·Ð©p¤F

­±¿n¸Õºâªí.rar (79.5 KB)

TOP

¦^´_ 5# dafa
«ö¤Uªí³æ«ö¶s °õ¦æ sub ´Óª«() Ū¨ú ¹ÏÀÉ ¥¿±`
¥i¥H°Ú,¬°¦ó¤£¦æ!!

TOP

¥»©«³Ì«á¥Ñ dafa ©ó 2012-12-9 07:54 ½s¿è

¦^´_ 6# GBKEE


    «Ü©êºp¥i¯à¬O§Ú¸ÑÄÀªº¤£²M·¡(¤£¾Õªí¹F)
          §ÚŪÀɳ£OK¦ý¥u­nExcelÃö³¬¡A¦b¦¸¥´¶}Excel§Ú¦b«ö¶s¬D¿ïªº¹Ï´N³£Åܤ£¨£¤F
          §Ú·Q­n§Ú¦A¦¸¥´¶}Excel®É¯à«O¯d©Ò¦³¤W¦¸¦b«ö¶s¤W¬Dªº¹Ï
                                                                     ¦A³Â·Ð±z¤F...........°®®¦³á ^^||

TOP

¦^´_ 6# GBKEE
¦^´_ 1# av8d
¦^´_ 5# dafa
GBKEE ª©¤j¡A ¦­¦w¡I
¥L­Ì«üªº·|¬O¡H
  1. Private Sub Workbook_Open()
  2.     '  For example purpose only.
  3. End Sub

  4. Private Sub Workbook_BeforeClose(Cancel As Boolean)
  5.     '  For example purpose only.

  6.     Me.Save
  7. End Sub
½Æ»s¥N½X

TOP

¦^´_ 7# dafa
¬°¦ó­n¨º»ò¦hªºCommandButton?¥Î¦óÅÞ¿è«Ø¥ß?

TOP

¦^´_ 9# GBKEE


    §Úªº¥Øªº¬O­n¨ÌUserform°µ©³¹ÏCommandButtonÂI®É¥i¥H¬D¿ï¬Y¨Ç¯S©w¹ÏÀɨөé¥X©³¹Ï
    CommandButton¥»¨­¬O¤@­Ó¤@­Ó¶K¤W¥hªº¨S¦³¶]µ{¦¡
    ¦pªG¨º»ò¦hªºCommandButton°µ¨ì¤@¥b¨S°µ§¹¤£¯à¦sÀÉ·|«Ü§xÂZ
    §Ú§ä¤F«Ü¤[¦n¹³¨S¤°»ò¤èªk¥i¥H¦sÀÉ
    ¦n¹³°£«D§â©Ò¦³CommandButton¹ïÀ³Àx¦s®æ¦A¦s¤J¹ïÀ³ªºÀɦW¤~¯à¸Ñ¨M

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD