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

¶i«×±ø¨Ï¥Î°ÝÃD?(¤w¸Ñ¨M)

¶i«×±ø¨Ï¥Î°ÝÃD?(¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ vackbin ©ó 2011-5-11 11:58 ½s¿è

Dear ¤j¤j­Ì

      ¤p§Ì·Q»s§@¤@­Ó¶i«×±ø , ¥¹µo²{§Úªº°Ê§@¬O"¨ú¥N"...¦ü¥GµLªk­p¼Æ...
¦Ó¥B¤p§Ìªí®æ¦@7¤d¦h­Ó¤£³W«hÄæ¦ì....¤£ª¾¦p¦óºâ¥XÁ`¶qªü@@

¸Ô¦pªþ¥ó...·Ð½Ð¤j¤jÀ°À°¤âªü!!
¶i«×±ø¨Ï¥Î.rar (15.33 KB)
Jack

¥»©«³Ì«á¥Ñ GBKEE ©ó 2011-5-9 06:58 ½s¿è

¦^´_ 1# vackbin
  1. Sub test1()
  2.     UserForm1.Show
  3. End Sub
½Æ»s¥N½X
  1. Private Sub UserForm_Activate()
  2.     Dim I&
  3.     ProgressBar1.Max = ActiveSheet.UsedRange.Cells.Count
  4.     For I = 1 To ActiveSheet.UsedRange.Cells.Count
  5.         DoEvents
  6.         ProgressBar1 = I
  7.         ActiveSheet.UsedRange.Cells(I).Replace What:="C", Replacement:="A" ', LookAt:=xlPart, SearchOrder _
  8.         :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
  9.     Next
  10.     MsgBox "§ó·s§¹¦¨!", vbInformation
  11.     Unload Me
  12. End Sub
½Æ»s¥N½X

TOP

GBKEE ©ó 2011-5-9 06:58 ½s¿è !!!!!
G¤j¯u¬O¦­°_ªü!!
·PÁ¤j¤j³o»ò§Ö´N¦^À³~~~¤p§Ì°¨¤W¸Õ¸Õ!!
Jack

TOP

Dear G¤j~~
¤p§Ì±N³¡¤À¿ù»~§R°£«á,µo²{¶i«×ªí¨Ã¤£·|°Ê~~
¦Ó¥B°»¿ù®Éµo²{ Unload MeªºMe¬O¤£¥¿½TªºÃöÁä¦r??
¬O§Ú¨Ï¥Îexcel 2003ª©ªºÃö«Y¶Ü?
¶i«×±ø¨Ï¥Î-Ans1.rar (16.24 KB)
Jack

TOP

¦^´_ 4# vackbin
¦Ñ§Ì: ³oµ{¦¡½X¬O­n©ñ¦bUserFormªí³æªºµ{¦¡½X
  1. Private Sub UserForm_Activate()
  2.     Dim I&
  3.     ProgressBar1.Max = ActiveSheet.UsedRange.Cells.Count
  4.     For I = 1 To ActiveSheet.UsedRange.Cells.Count
  5.         DoEvents
  6.         ProgressBar1 = I
  7.         ActiveSheet.UsedRange.Cells(I).Replace What:="1", Replacement:="A", LookAt:=xlPart, SearchOrder _
  8.         :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
  9.     Next
  10.     MsgBox "§ó·s§¹¦¨!", vbInformation
  11.    Unload Me
  12. End Sub
½Æ»s¥N½X

TOP

¥Î¶i«×±ø·|©ìºC¨t²Îªº

Replace¤èªk¥»¨ÓÀþ¶¡´N§¹¦¨ªº
¥[¤W¶i«×±ø¥²µMºC¤U¨Ó¤F

TOP

Dear G¤j~~
   ´ú¸Õ«á¥¿½T!!!!·PÁ±zªº«ü¾É~~~

TO chin15 ~~
¦]¬°¤u§@¤W±`»Ý­n¨ú¥N³o­Ó°Ê§@~Áö³]­p¥¨¶°Åý¦P¨Æ¨Ï¥Î~~
¦ý¬O®É¶¡ÆZ¤[ªº±`µo¥Í¦P¨Æ¥H¬°·í¾÷±j¨îÃö³¬³y¦¨¿ù»~~~
©Ò¥H·Q°µ­Ó¶i«×±ø§ïµ½ªü~~~
§Ú¥u¬O¤p§U¤âºÉ¶qÀ°À°¥L­Ìªº¦£ªü~~¤]Åý§Ú¤£­n¦Ñ°µ¨Ç°£¿ùªº¨Æ
Jack

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD