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

¦³¿ìªk­­¨î¨Ï¥Î¤è¦¡¶Ü?

¦³¿ìªk­­¨î¨Ï¥Î¤è¦¡¶Ü?

½Ð°Ý¤j¤j
¦]¬°ªí³æ¥\¯à¤w¸g¼g¦n¤F
·Q­n±j¨îÅý¨Ï¥ÎªÌ¥u¯à¥Îªí³æ¿é¤J
§_«h´NÅܦ¨¤]¥i¥Hª½±µÂIÀx¦s®æ¶i¦æ¿é¤Jªº°Ê§@
¨º³o¼Ë³]­pªí³æ¿é¤J´N¨S¦³·N¸q¤F

¦ý¬OExcel«OÅ@¤u§@ªíªº¥\¯à
·|¦P®É±N½s¿è¥\¯àÂê¦í
¨Ï¥ÎVBA³]­p¥X¨Óªºªí³æ¤]¨S¿ìªk¿é¤J¸ê®Æ¤W¥h

¦³¨ä¥Lªº¿ìªk
¥i¥HÂê¦í¤@¯ë¿é¤J¤è¦¡
¦Ó¤£·|¤]Åܦ¨VBA¤£¯à±N¸ê®Æ¿é¤J¶i¥hªºµ~¹Ò? ><
Jared

¦^´_ 1# Jared
¸Õ¸Õ¬Ý
  1. Private Sub UserForm_Initialize()
  2.     Application.Visible = False
  3. End Sub
  4. Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
  5.     Application.Visible = True
  6. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 2# GBKEE


ÁÂÁ¤j¤jªº¨ó§U
³oºØ¤è¦¡¬O¥ýÃö³¬ÀÉ®×
¥u¦³¥X²{ªí³æ¨Ó¶i¦æ¶ñ¼gªº¤è¦¡
¦ý¬O¦³¿ìªk¥ý±N©Ò¦³Àx¦s®æ¥ýÂê°_¨Ó
µM«á·í¶}±Òªí³æ¥\¯àªº®É«á·|¥ý¸Ñ¶}
«Ý¸ê®Æ¶ñ¼g§¹¦¨«ö¤U°e¥X«á¦AÂê°_¨Ó©O? (@@)
Jared

TOP

¦^´_ 1# Jared


    ¤@¯ëªí³æ­Y¨S¯S§O«ü©w¡A¬OÄÝ©ó±j¨î¦^À³ªí³æ
¤]´N¬O»¡§Aªºªí³æÅã¥Ü®É¡AµLªk¦bEXCEL¤u§@ªí¤º§@¥Î¡AÀ³¸Ó¤w¸g²Å¦X§Aªº»Ý¨D
§A·|¦³¦¹°ÝÃD¡AÀ³¸Ó¬O¦b¶}±Òªí³æªº«ü¥O¤¤¥[¤W±j¨î¦^À³°Ñ¼Æ¤~·|¦³¿ìªk¦bÀx¦s®æ¤º¿é¤J
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# Jared
±NUserForm ³]¬°±j¨î¦^À³,´N¥i¤£°Ê¨ì¤u§@ªí
  1. UserForm1.Show 1  
½Æ»s¥N½X
¦p­n¤u§@ªíªº¤WÂê,¥i¿ý»s«á®M¨ìUserFormªºµ{¦¡½X¤W¸Õ¸Õ¬Ý
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 4# Hsieh


  ÁÂÁ¤j¤jªº«Øij¡A§Ú¦A¹Á¸Õ¬Ý¬Ý
Jared

TOP

¦^´_ 5# GBKEE


   ÁÂÁ¤j¤j¡A»°ºò¸Õ¬Ý¬Ý^^
Jared

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD