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

[µo°Ý] ½Ð°Ý¸Ó«ç»òÅýExcel¸Ì­±ªº®Ö¨ú¤è¶ô(checkbox)¥þ¿ï©O

[µo°Ý] ½Ð°Ý¸Ó«ç»òÅýExcel¸Ì­±ªº®Ö¨ú¤è¶ô(checkbox)¥þ¿ï©O

¤p§Ì¬Oexcel¶W·s¤âQQ¡A

²{¦b¦n¤£®e©ö°µ¦n¤F´X­Ó®Ö¨ú¤è¶ô¡A¦ý¨C¦¸­nÂI¿ï¥L­Ì¥þ³¡/¨ú®ø ¿ï¨ú®É³£­n¤@­Ó¤@­ÓÂIÀ»¡A

½Ð°Ý¦³¤°»ò¤èªk¥i¥HÅý¥L­ÌÂI¤@­Ó®Ö¨ú¤è¶ô«á¡A¥þ¿ï/¨ú®ø¶Ü?

¥ýÁÂÁ¦U¦ì¥ý¶i­Ìªº±Ð¾É> <

Dim CKB As CheckBox
For Each CKB In ActiveSheet.CheckBoxes
¡@¡@CKB.Value = xlOn¡@'¥þ¨ú®ø¤Ä¿ï = xlOff
Next

TOP

ÁÂÁ¤j¤j¦^ÂÐ ¤£¹L¦]¬°¬O¶W·s¤â©Ò¥H¬Ý¤£¤ÓÀ´¤j¤jªº¦^µªorz

§Ú¥ý ¥hª¦­Ó¤å ¦pªGÁÙ¬O¦³¤£À´ªº¦a¤è¦A¦^ÀY½Ð±Ð¤j¤j¡AÁÂÁÂ~

TOP

©óø¹Ï¥\¯àÁ䤺¤§ ½bÀY§Îª¬¤§¿ï¥hª«¥ó  «ö¤§  µM«á¥Î·Æ¹«¿ï¨ú½d³ò¤º¤§ALL  ®Ö¨ú¤è¶ô
¥i¤@¦¸§R°£
ù

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD