[µo°Ý] ¦p¦ó¹w¯dªÅ¶¡µ¹Äæ¦ì? §PÂ_CheckBox=True

av8d

For  i = 1 To  100
If Me.Controls("CheckBox" & i).Value = True

¥Ø«e§Ú¦³CheckBox1~CheckBox50
¦pªG§Ú·Q¹w¯dCheckBox50~100
©Ò¥H·í§PÂ_¤W¦Cµ{¦¡~·|¥X²{¿ù»~~
§Ú¸Ó¦p¦óÁ׶}³o­Ó¿ù»~!?

GBKEE

¦^´_ 1# av8d
¦pªG§Ú·Q¹w¯dCheckBox50~100  ½Ð»¡²M·¡
Àˬd ©Ò¦³±±¨î¶µªº¦WºÙ §t¦³ "CheckBox" ¦r¦ê ¤Î­È= True

1. Private Sub Ex()
   
2.     Dim i As Integer
   
3.     For i = 0 To Controls.Count - 1
   
4.         If InStr(Controls(i).Name, "CheckBox") > 0 And Controls(i) = True Then
   
5.          MsgBox Controls(i).Value
   
6.         End If
   
7.     Next
   
8. End Sub

½Æ»s¥N½X