- ©«¤l
- 835
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 915
- ÂI¦W
- 14
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-11-6
|
¥»©«³Ì«á¥Ñ luhpro ©ó 2014-10-20 21:40 ½s¿è
¬YÅܼƥu¥Î¦b¦Û¤wªº¤u§@ªí( private)
·Q¦b§Oªº¤u§@ªí¸Ìªºµ{§Ç§ïÅÜ¥¦ªºÈ?¦p¦ó°µ?
t8899 µoªí©ó 2014-10-20 19:44
private -> Public
bobomi µoªí©ó 2014-10-20 21:02
¸É¥R 2#
1. ÅܼƳ]¬° Public ¥u¥i©ñ¦b ²Ä¤@Ó Sub «ü¥Oªº¤W¤è,
¥B©ñ¦b Option Explicit ªº¤W¤è©Î¤U¤è¬Ò¥i.
2. °²³]¦b Sheets("Sheet1") ¦³³]©w Public vN
«h¦b«D Sheets("Sheet1") ¤¤¨Ï¥Î®É, (¨Ò¦p Sheets("Sheet3"), ©Î¬O ThisWorkBook...)
n¥Î Sheets("Sheet1").vN ªº§Î¦¡¨Ó¨Ï¥Î¸ÓÅܼÆ.
3. Y·Q¦b©Ò¦³°Ï°ì¦@¥Î¦¹ÅܼÆ,
½Ð±N¸Ó Public ªºÅܼƳ]¦b Module ¤º.
4. Y¥Hª«¥ó¾É¦Vªº·§©À¨Ó°µªº¸Ü,
À³¸Ó¬O±N¸ÓÅܼƳ]¬° Private ,
¦Ó¦b¸Ó Sheet ¤º·s¼W¤@Ó Public Sub µ{§Ç¦W(±ý³]©wªºÈ) ªº¤è¦¡¨Ó¹ê²{קï©ÎÅã¥Ü¸ÓÅܼƪº¥\¯à,
¬Û¦Pªº¥i¥Î Sheets("Sheet1"). µ{§Ç¦W(±ý³]©wªºÈ) ªº§Î¦¡©I¥sק惡ÅܼƤº®e.
³o¼Ëªº¸ÜY¤£³z¹L³oÓµ{§Ç¬OµLªkק惡Åܼƪº. |
|