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

[µo°Ý] ½Ð°Ý¦p¦ó­«½Æ¬Y¤@¬q»yªk?

[µo°Ý] ½Ð°Ý¦p¦ó­«½Æ¬Y¤@¬q»yªk?

¤£¦n·N«ä~§Ú¬O·s¤â¤]¬O²Ä¤@¦¸µo°Ý~§Ú¦³­Ó°ÝÃD·Q½Ð±Ð¡A¬O³o¼Ëªº~
§Ú¦bexcel¥ÎVBA´¡¤J¤F¤@­Óªí®æ¡A¸Ì­±¥]§tcheckbox5~45
§Ú§Æ±æ·í¥L­Ì¬°trueªº®É­Ô¡A¥i¥H¶]§Ú¦b¸Ì­±¤w¸g¼g¦nªº¬Y¤@¬q»yªk?
§Ú¸Ó«ç»ò°µ?

  1. Sub test()
  2. For i = 5 To 55
  3.     If Controls("checkbox" & i) = True Then
  4.         '±Nµ{¦¡½X¼g¦b³o
  5.     End If
  6. Next
  7. End Sub
½Æ»s¥N½X
PKKO

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD