Thread: Checkbox Macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GJones GJones is offline
external usenet poster
 
Posts: 132
Default 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/

.