| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count CheckBoxes in UserForm
Lenny,
Try something like the following: Dim Ctrl As MSForms.Control Dim N As Long For Each Ctrl In UserForm1.Controls If TypeOf Ctrl Is MSForms.CheckBox Then N = N + 1 End If Next Ctrl -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Lenny_821" wrote in message ... Hi All, I've got a few CheckBoxes in a UserForm. How can I count the CheckBoxes in VBA?? Please help:) Lenny -- Lenny_821 ------------------------------------------------------------------------ Lenny_821's Profile: http://www.excelforum.com/member.php...o&userid=15179 View this thread: http://www.excelforum.com/showthread...hreadid=319438 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform Checkboxes | Excel Discussion (Misc queries) | |||
| Userform with Checkboxes | Excel Discussion (Misc queries) | |||
| Can't check checkboxes in userform ... sometimes | Excel Programming | |||
| UserForm Checkboxes | Excel Programming | |||
| add multiple checkboxes to userform at runtime | Excel Programming | |||
Threaded Mode
