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

[µo°Ý] VBA ªí³æ ¹Ï§Î ¬°¦óµLªk¦Ü³Ì¤W¼h

VBA¥i§_´¡¤JPNGÀÉ®×

½Ð°Ý¦U¦ì¤j¤j¡A§Ú·Q»s§@¤@­Óªí³æ¡A·Q¨Ï¥ÎPNGªº¹ÏÀɨӥh°£­I´º¦â
¦ý·í§Ú¸ü¤JPNGÀɮ׮ɡA¥L¼g"Àɮפ£¥¿½T"½Ð°Ý¦³¤°»ò¤è¦¡¥i¥H¸ü¤J¹Ï¤ù¤S¥i¥h°£­I´º¦â¶Ü??

TOP

VBA ªí³æ¸Ì­±ªº´¡¤J¹Ï¤ù¡A¥i§_±ÛÂà

½Ð°Ý¦U¦ì¤j¤j¡A§Ú·Q¦bVBAªºªí³æ¤¤´¡¤J¹Ï¤ù¡A¦ý§Ú·QÅý¥L¦³°Êªº·Pı
§Ú¥i¥HÅý¹Ï¤ù°µ¨ì¦³¥ª¥kÂ\°Êªº·Pı¶Ü??

TOP

转¦¨Gif图¤ù试试¡C
¥@¬É¨º»ò¤j¡A¥i§Ú·Q¥h­þ¡H

TOP

¦^´_ 3# Joforn

¥i¬O§Ú¦bªí³æ¤¤´¡¤Jgif ÀÉ¡A¥L¤£·|°Ê

TOP

¤p§Ì§Ú¬ðµo©_·Q¡A¥ÎÄFªº¤è¦¡¡A¶K¤T±i¹Ï¦Üªí³æ¤¤¡AµM«á©w®É­×§ï¦Ü³»ªí³æ
¦ý²{¦bµo²{«Ü©_©Ç¡A³sÄò°õ¦æ®É¡A¬Ý¤£¥X®ÄªG¡A³æ°Êªº®É­Ô´N¥i¥H¡A½Ð°Ý¸Ó«ç»ò¸Ñ¨M??
¥t¥~¡A§Ú¦³¿ìªkÅý³o¦^°é¤@ª½¶]¡AÁÙ¥i¥H°õ¦æ¨ä¥L°Ê§@¶Ü??
·s¼W Microsoft Excel ¤u§@ªí.zip (193.92 KB)

TOP

[µo°Ý] VBA ªí³æ ¹Ï§Î ¬°¦óµLªk¦Ü³Ì¤W¼h

¥»©«³Ì«á¥Ñ lichang ©ó 2015-9-16 23:22 ½s¿è

¦U¦ì¤j¤j¡A¦]¬°¦³¬d¤F¤@¤UEXCEL VBA¦n¹³¤£¤ä´©GIF°ÊºAÀÉ(¥~±¾°£¥~)
©Ò¥H«Ü¤Ñ¯uªº·Q¡A¨º¥Î¤T±i¹Ï¡A«ö·Ó©µ¿ð®É¶¡¨ÓÅý·Ó¤ù¦Ü³»¡A·í§@°ÊºAªº·Pı!!
(¤£·Q¨Ï¥Î¥~³¡´¡¤J¹ÏÀɪº¤è¦¡¡A¦]¬°³o¼Ë§ÚÁÙ­n«O¦s¹ÏÀÉ)
¦ý²{¦bµo²{¡A¨Ï¥Î³æ°Êªº®É­Ô¡A¥i¥H¦³®ÄªG¥X²{¡A¦ý·í³sÄò°Ê§@®É¡A«oµLªk¹F¨ì¦¹®ÄªG!!
¤£ª¾¹D¦³­þ¦ì¤j¤j¯àÀ°§Ú¸Ñ´b¤@¤U¶Ü??¸Ó¦p¦ó­×¥¿!!

¥t¥~¤@°Ý¡A¦pªG³o¤@Ãö¹L¤F¡A§Ú¦³¿ìªk¼g¦¨µL­­°j°é¡A°£«D§Ú¤SÂIÀ»¨ä¥L«öÁä¤~°h¥X¡A¥i¥H¶Ü??

·s¼W Microsoft Excel ¤u§@ªí.zip (185.56 KB)

¦^´_ 6# lichang
¸Õ¸Õ¬Ý
  1. #If VBA6 Then
  2. Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) 'For 32 Bit Systems
  3. #Else
  4. Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) 'For 64 Bit Systems
  5. #End If
  6. Dim Msg As Boolean 'Boolean  ªì©l­ÈFalse
  7. Private Sub CommandButton1_Click()
  8.    Msg = Not Msg  '¤ÏÂà:·íTrueÂରFalse,·íFalseÂରTrue
  9.    Image_ZOrder
  10. End Sub
  11. Private Sub Image_ZOrder()
  12.     Dim Ar(), i As Integer, t As Date
  13.     Ar = Array(Image1, Image2, Image3)
  14.     t = Time
  15.     Do While Msg  'Msg=True °õ¦æ³o Do Loop ªº°j°é
  16.         DoEvents
  17.         'Sleep 1000
  18.         If t + #12:00:01 AM# <= Time Then  '¨C¬í¤@¦¸,¤]¥i¥H¤£¥Î Sleep
  19.             Ar(i).ZOrder msoBringToFront
  20.             i = i + 1
  21.             If i > UBound(Ar) Then i = 0
  22.             t = Time
  23.         End If
  24.     Loop
  25. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 7# GBKEE

ª©¥D§A«ç»ò³o»ò¼F®`¡A½Ð°Ý¤@¤U¡A§Úªº¥Îªk¸Ì­±¬O­þ­Ó¥X²{°ÝÃD¤~¾É­P¤£¯à¨Ï¥Î©O??

sleep¨ç¦¡¶Ü??ÁÙ¬O¨S¦³¥Î°}¦C¼¶¼g??

TOP

¦^´_ 8# lichang
   sleep ¤§«e¥[ DoEvents

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD