ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   checkBox help!!! (https://www.excelbanter.com/excel-discussion-misc-queries/121678-checkbox-help.html)

riggi

checkBox help!!!
 
Hi,
I am trying to write this checkbox code, I dunno for some reason its
not working. Please tell me whats wrong in it. I will really
appreciate.

Thanks,

Riggi


Sub CheckBox1_Click()

If Checkbox1.Value = True Then
MsgBox (" Checked ")
Else
MsgBox ("unchecked")
End If
End Sub


Bob Phillips

checkBox help!!!
 
It works fine if the checkbox is a control toolbox checkbox, and if you put
the code in that sheet code module.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"riggi" wrote in message
ups.com...
Hi,
I am trying to write this checkbox code, I dunno for some reason its
not working. Please tell me whats wrong in it. I will really
appreciate.

Thanks,

Riggi


Sub CheckBox1_Click()

If Checkbox1.Value = True Then
MsgBox (" Checked ")
Else
MsgBox ("unchecked")
End If
End Sub





All times are GMT +1. The time now is 04:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com