Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting ctl to array of checkboxes yields type mismatch error.
No, I actually want to create an array of checkbox objects
that I can then loop thru and THEN check to see if they are true or false (checked or unchecked). I need the objects as CHECKBOX objects. Thanks. -----Original Message----- Tritan Dim ChkBoxes() As Variant This sets each entry in the array to True or False. Is that what you want ? Regards Trevor "Tritan" wrote in message ... Dim ChkBoxes() As CheckBox Dim Ctl As Control Dim j As Integer j = 0 For Each Ctl In Me.Controls If TypeName(Ctl) = "CheckBox" Then j = j + 1 ReDim Preserve ChkBoxes(1 To j) error- Set ChkBoxes(j) = Ctl End If Next Ctl have several checkboxes on a user form that I would like to manipulate in a for loop. (setting various ranges differently based on the which checkbox is checked) When I step thru it Ctl is 'true'. I want to add a CheckBox to my array not a true. What am I doing wrong. Any help would be appreciated. Thanks, Tritan . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Type Mismatch Error | Excel Discussion (Misc queries) | |||
Type Mismatch Error - Help Please | Excel Worksheet Functions | |||
Type Mismatch Error | Excel Discussion (Misc queries) | |||
Why type mismatch - R/T error 13 | Excel Discussion (Misc queries) |