¨D±Ð¦³ÃöUserForm¨Ï¥Î§¹«á¤£¦û°O¾ÐÅ骺²M°£¤èªk
- ©«¤l
- 824
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 904
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2023-12-24
|
¥»©«³Ì«á¥Ñ luhpro ©ó 2016-3-26 00:21 ½s¿è
¦^´_ 1# clio
¥H¤U¬O Excel VBA ªº»¡©ú :
¤@¯ë·í¨Ï¥Î Set ¨Ó¤Þ¥Îª«¥óµ¹ÅܼƮɡA
¨Ã«D½Æ»s¤@¥÷ª«¥óµ¹ÅܼơA
¦Ó¬O«Ø¥ß¤@¥÷¹ï¸Óª«¥óªº¤Þ¥Î¡C (µù : ³o¸Ì©Ò¿×ªº¤Þ¥Î, ³Ì²³æªº¨Ò¤l´N¬OExcel¬¡¶Ã¯¤¤¬YÓÀx¦s®æªº¦ì§}, ÂǥѳoÓ¦ì§}¥i¥H¤Þ¥Î¨ì<¨ú±o>¦¹Àx¦s®æªº¤º®e,¦r«¬...)
¶W¹L¤@Ó¥H¤Wªºª«¥óÅܼƥi¥H¤Þ¥Î¬Û¦Pªºª«¥ó¡C
¦]¬°ÅܼƬO¤Þ¥Î¸Óª«¥ó¡A
¦Ó¤£¬O¤Þ¥Î¸Óª«¥óªº½Æ»s«~¡A
¸Óª«¥óY§ïÅÜ¡A
«h©Ò¦³¤Þ¥Î¥¦ªºÅܼƤ]·|¸òµÛ§ïÅÜ¡C
µM¦Ó¡AY¦b Set ³¯z¦¡¤W¨Ï¥Î New ÃöÁä¦r¡A
«h·|¯uªº«Ø¥ß¸Óª«¥óªº°õ¦æÓÅé¡C (µù : ÁöµM«Ø¥ß¤F ¤@Óª«¥ó, ¸ÓÅܼƤ´µMÁÙ¬O¤@¥÷¹ï¸Óª«¥óªº¤Þ¥Î)
©Ò¥H Set AForm = Nothing ¨ä¹ê¥u¬O²MªÅ¸ÓÅÜ¼Æ (¥¢¥h¤Þ¥Î¥\¯à),
§¹¥þ¨S¦³°Ê¨ì¸Óª«¥óªº¥»Åé.
¦Ü©ó Unload ªº»¡©ú :
±N¤@Óª«¥ó¦Û°O¾ÐÅ餤²¾°£¡C
ÅU¦W«ä¸q.
¨ä¹ê°£«D¦bµ{¦¡°õ¦æ¹Lµ{¤¤¤~°ÊºA«Ø¥ßª«¥ó,
§_«h·í¶}±ÒÀɮ׫á°O¾ÐÅ餺´N¤w¦s¤F¤@¥÷¸Óª«¥óªº¸ê®Æ¤F.
³Ì²³æªºÅçÃҤ覡 -
¶}±ÒExcel ¦sÀÉ«¶}¬Ý¬Ý¨Ï¥Îªº°O¾ÐÅéªÅ¶¡¶q,
±µµÛ¥[ÓUserForm«á¦sÀÉ«¶}¦A¬Ý¬Ý¨Ï¥ÎªºªÅ¶¡¶q,
·|µo²{§Y¨Ï¨S¥Îµ{¦¡ Load ©Î Show ·Ó¼Ë¨Ï¥ÎªºªÅ¶¡·|¸û¦h.
·íµMY Load ©Î Show ¤F«áªÅ¶¡·|¥Î§ó¦h. |
|
|
|
|
|
|