Aleng
New Member
- Joined
- Jul 27, 2010
- Messages
- 37
Hi,
If i check userform check1 then i want sheet1.checkbox1 to get checked(Ticked)..else if unchecked then do vice versa...
Please help me with the userform code.
Thanks
If i check userform check1 then i want sheet1.checkbox1 to get checked(Ticked)..else if unchecked then do vice versa...
Please help me with the userform code.
Thanks
Code:
'this code is not working
Private Sub CheckBox2_Click()
Select Case CheckBox1.Value
Case True
'CheckBox1.Caption = "True"
Sheets1.CheckBox1
Case False
'CheckBox1.Caption = "False"
Sheets1.CheckBox1 = False
End Select
End Sub
Last edited: