Checkbox Macro
 

I have a checkbox of which I need macro for. The only thing I need it t
do it if I click on it and it is checked, a button next to it shoul
appear which is already made(button's name is "Thread"). And if it i
not checked I don't want the button to be there. And the box starts of
as unchecked. THANK

--
Message posted from http://www.ExcelForum.com

Checkbox Macro
 

Dear grin;

Use the code below;

Thanks, Greg

Private Sub CheckBox1_Change()
If CheckBox1.Value = True Then
Thread.Visible = True
ElseIf CheckBox1.Value = False Then
Thread.Visible = False
End If

End Sub



Private Sub UserForm_Activate()
Thread.Visible = False

End Sub


-----Original Message-----
I have a checkbox of which I need macro for. The only
thing I need it to
do it if I click on it and it is checked, a button next
to it should
appear which is already made(button's name is "Thread").
And if it is
not checked I don't want the button to be there. And the
box starts off
as unchecked. THANKS


---
Message posted from http://www.ExcelForum.com/

.

Checkbox Macro
 

or more simply

Private Sub CheckBox1_Change()
Thread.Visible = Checkbox.Value
End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Gjones" wrote in message
...
Dear grin;

Use the code below;

Thanks, Greg

Private Sub CheckBox1_Change()
If CheckBox1.Value = True Then
Thread.Visible = True
ElseIf CheckBox1.Value = False Then
Thread.Visible = False
End If

End Sub



Private Sub UserForm_Activate()
Thread.Visible = False

End Sub


-----Original Message-----
I have a checkbox of which I need macro for. The only
thing I need it to
do it if I click on it and it is checked, a button next
to it should
appear which is already made(button's name is "Thread").
And if it is
not checked I don't want the button to be there. And the
box starts off
as unchecked. THANKS


---
Message posted from http://www.ExcelForum.com/

.