Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox Macro | Excel Discussion (Misc queries) | |||
checkbox macro | Excel Discussion (Misc queries) | |||
Macro for checkbox (2) | Excel Discussion (Misc queries) | |||
Macro for checkbox (2) | Excel Discussion (Misc queries) | |||
Macro for checkbox | Excel Discussion (Misc queries) |