Checking a Check Box in Excel

  • Thread starter Thread starter Frenchie
  • Start date Start date
F

Frenchie

How do I check a check box in Excel. I need to know what to put in

Private Sub CheckBox1_Click()
'this bit here'
End Su
 
Private Sub CheckBox1_Click()
if checkbox1.Value = True then
msgbox "box is checked"
else
msgbox "box is not checked"
End if
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

protect worksheet with check box 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Unhiding Check Boxes in Excel 2002 1
Password Change 2
How to use a Checked Control Box in a formula 1
Check Box comment 3
Form Control vs. Active X Controls 7
Check if Excel is open in Word VBA 0

Back
Top