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/
.