Hi,
I have a UserForm in Excel 2k and i'm trying to assign a value to each CheckBox on the form when it is closed.
I have part of the code as below;
This loops through each control and identifies the CheckBoxes, but when i try to assign a false value to each one, i find that it is not possible to use the
method.
When i attempt to use
i get an error stating "Object does not support this method".
Can anyone lend a hand with this please?
Thanks in advance.
Leigh Moore
Solutions 4 MS Office Ltd
I have a UserForm in Excel 2k and i'm trying to assign a value to each CheckBox on the form when it is closed.
I have part of the code as below;
Code:
Private Sub cmdExit_Click()
Dim c As Control
For Each c In Me.Controls
If Left(c.Name, 3) = "chk" Then
End If
Next c
Me.Hide
End Sub
This loops through each control and identifies the CheckBoxes, but when i try to assign a false value to each one, i find that it is not possible to use the
Code:
.Value
When i attempt to use
Code:
c.Value = False
Can anyone lend a hand with this please?
Thanks in advance.
Leigh Moore
Solutions 4 MS Office Ltd