Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a checkbox
I have been playing around with controls on excel 2007 and am getting
frustrated ofver something I am sure is very simple...I simply want to perform an action when a checkbox = true. I have the following code: Sub CheckBox1_Click() If CheckBox1 = True Then ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub For some reason this code does not recognize when the checkbox is true or not. can someone point me in the right direction? Thanks! Chad |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a checkbox
On 11 Jul., 00:11, Chad wrote:
I have been playing around with controls on excel 2007 and am getting frustrated ofver something I am sure is very simple...I simply want to perform an action when a checkbox = true. *I have the following code: Sub CheckBox1_Click() If CheckBox1 = True Then * * ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub For some reason this code does not recognize when the checkbox is true or not. *can someone point me in the right direction? Thanks! Chad Hi If CheckBox1.Value = True Then Regards, Per |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a checkbox
Is this a checkbox from the Control toolbox toolbar or is this a checkbox from
the Forms toolbar? If it's from the control toolbox toolbar, then is your code under the worksheet that holds that checkbox? If it's from the Forms toolbar, then the code belongs in a General module and needs to be modified. Did you allow macros to run when you opened the workbook? Chad wrote: I have been playing around with controls on excel 2007 and am getting frustrated ofver something I am sure is very simple...I simply want to perform an action when a checkbox = true. I have the following code: Sub CheckBox1_Click() If CheckBox1 = True Then ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub For some reason this code does not recognize when the checkbox is true or not. can someone point me in the right direction? Thanks! Chad -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a checkbox
I believe that the checkbox is from the forms toolbar (Is Office 2007 I go
under the Developer tab and then select 'Insert Control" and choose the textbox under the form controls). I have the code running under a module. The sub routine is called when the checkbox is clicked, however, regardless of whether it is checked or not, CheckBox1 is always recognized as False. Thanks again for al lo fyour help. Chad "Dave Peterson" wrote: Is this a checkbox from the Control toolbox toolbar or is this a checkbox from the Forms toolbar? If it's from the control toolbox toolbar, then is your code under the worksheet that holds that checkbox? If it's from the Forms toolbar, then the code belongs in a General module and needs to be modified. Did you allow macros to run when you opened the workbook? Chad wrote: I have been playing around with controls on excel 2007 and am getting frustrated ofver something I am sure is very simple...I simply want to perform an action when a checkbox = true. I have the following code: Sub CheckBox1_Click() If CheckBox1 = True Then ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub For some reason this code does not recognize when the checkbox is true or not. can someone point me in the right direction? Thanks! Chad -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a checkbox
I was playing around a little bit more and I used the ActiveX controls to
insert a checkbox and it worked. Can someone tell me why inserting a checkbox from the control toolbar doesn't work with this code? Thanks! Chad "Chad" wrote: I believe that the checkbox is from the forms toolbar (Is Office 2007 I go under the Developer tab and then select 'Insert Control" and choose the textbox under the form controls). I have the code running under a module. The sub routine is called when the checkbox is clicked, however, regardless of whether it is checked or not, CheckBox1 is always recognized as False. Thanks again for al lo fyour help. Chad "Dave Peterson" wrote: Is this a checkbox from the Control toolbox toolbar or is this a checkbox from the Forms toolbar? If it's from the control toolbox toolbar, then is your code under the worksheet that holds that checkbox? If it's from the Forms toolbar, then the code belongs in a General module and needs to be modified. Did you allow macros to run when you opened the workbook? Chad wrote: I have been playing around with controls on excel 2007 and am getting frustrated ofver something I am sure is very simple...I simply want to perform an action when a checkbox = true. I have the following code: Sub CheckBox1_Click() If CheckBox1 = True Then ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub For some reason this code does not recognize when the checkbox is true or not. can someone point me in the right direction? Thanks! Chad -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a checkbox
I have played around with the value property as well, but when I use that
code, I get an error saying that an object is required... "Per Jessen" wrote: On 11 Jul., 00:11, Chad wrote: I have been playing around with controls on excel 2007 and am getting frustrated ofver something I am sure is very simple...I simply want to perform an action when a checkbox = true. I have the following code: Sub CheckBox1_Click() If CheckBox1 = True Then ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub For some reason this code does not recognize when the checkbox is true or not. can someone point me in the right direction? Thanks! Chad Hi If CheckBox1.Value = True Then Regards, Per |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a checkbox
The activeX controls and the controls from the Control toolbox toolbar are
different terms for the same controls. If you used the checkbox (not textbox) from the Forms toolbar, you could have used: Sub CheckBox1_Click() If activesheet.checkboxes("CheckBox1").value = xlon Then ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub Chad wrote: I was playing around a little bit more and I used the ActiveX controls to insert a checkbox and it worked. Can someone tell me why inserting a checkbox from the control toolbar doesn't work with this code? Thanks! Chad "Chad" wrote: I believe that the checkbox is from the forms toolbar (Is Office 2007 I go under the Developer tab and then select 'Insert Control" and choose the textbox under the form controls). I have the code running under a module. The sub routine is called when the checkbox is clicked, however, regardless of whether it is checked or not, CheckBox1 is always recognized as False. Thanks again for al lo fyour help. Chad "Dave Peterson" wrote: Is this a checkbox from the Control toolbox toolbar or is this a checkbox from the Forms toolbar? If it's from the control toolbox toolbar, then is your code under the worksheet that holds that checkbox? If it's from the Forms toolbar, then the code belongs in a General module and needs to be modified. Did you allow macros to run when you opened the workbook? Chad wrote: I have been playing around with controls on excel 2007 and am getting frustrated ofver something I am sure is very simple...I simply want to perform an action when a checkbox = true. I have the following code: Sub CheckBox1_Click() If CheckBox1 = True Then ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub For some reason this code does not recognize when the checkbox is true or not. can someone point me in the right direction? Thanks! Chad -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a checkbox
Thanks for the clarification Dave. I tried that and got an error saying:
'Unable to get the CheckBoxes property of the Worksheet class' Any suggestions? Again, I am using office 2007. Thanks again! Chad "Dave Peterson" wrote: The activeX controls and the controls from the Control toolbox toolbar are different terms for the same controls. If you used the checkbox (not textbox) from the Forms toolbar, you could have used: Sub CheckBox1_Click() If activesheet.checkboxes("CheckBox1").value = xlon Then ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub Chad wrote: I was playing around a little bit more and I used the ActiveX controls to insert a checkbox and it worked. Can someone tell me why inserting a checkbox from the control toolbar doesn't work with this code? Thanks! Chad "Chad" wrote: I believe that the checkbox is from the forms toolbar (Is Office 2007 I go under the Developer tab and then select 'Insert Control" and choose the textbox under the form controls). I have the code running under a module. The sub routine is called when the checkbox is clicked, however, regardless of whether it is checked or not, CheckBox1 is always recognized as False. Thanks again for al lo fyour help. Chad "Dave Peterson" wrote: Is this a checkbox from the Control toolbox toolbar or is this a checkbox from the Forms toolbar? If it's from the control toolbox toolbar, then is your code under the worksheet that holds that checkbox? If it's from the Forms toolbar, then the code belongs in a General module and needs to be modified. Did you allow macros to run when you opened the workbook? Chad wrote: I have been playing around with controls on excel 2007 and am getting frustrated ofver something I am sure is very simple...I simply want to perform an action when a checkbox = true. I have the following code: Sub CheckBox1_Click() If CheckBox1 = True Then ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub For some reason this code does not recognize when the checkbox is true or not. can someone point me in the right direction? Thanks! Chad -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a checkbox
Rightclick on the checkbox.
Look at the namebox (to the left of the formula bar) You'll see its name. If it's "Check Box 1", then you'd use: ActiveSheet.CheckBoxes("Check Box 1").Value Chad wrote: Thanks for the clarification Dave. I tried that and got an error saying: 'Unable to get the CheckBoxes property of the Worksheet class' Any suggestions? Again, I am using office 2007. Thanks again! Chad "Dave Peterson" wrote: The activeX controls and the controls from the Control toolbox toolbar are different terms for the same controls. If you used the checkbox (not textbox) from the Forms toolbar, you could have used: Sub CheckBox1_Click() If activesheet.checkboxes("CheckBox1").value = xlon Then ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub Chad wrote: I was playing around a little bit more and I used the ActiveX controls to insert a checkbox and it worked. Can someone tell me why inserting a checkbox from the control toolbar doesn't work with this code? Thanks! Chad "Chad" wrote: I believe that the checkbox is from the forms toolbar (Is Office 2007 I go under the Developer tab and then select 'Insert Control" and choose the textbox under the form controls). I have the code running under a module. The sub routine is called when the checkbox is clicked, however, regardless of whether it is checked or not, CheckBox1 is always recognized as False. Thanks again for al lo fyour help. Chad "Dave Peterson" wrote: Is this a checkbox from the Control toolbox toolbar or is this a checkbox from the Forms toolbar? If it's from the control toolbox toolbar, then is your code under the worksheet that holds that checkbox? If it's from the Forms toolbar, then the code belongs in a General module and needs to be modified. Did you allow macros to run when you opened the workbook? Chad wrote: I have been playing around with controls on excel 2007 and am getting frustrated ofver something I am sure is very simple...I simply want to perform an action when a checkbox = true. I have the following code: Sub CheckBox1_Click() If CheckBox1 = True Then ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub For some reason this code does not recognize when the checkbox is true or not. can someone point me in the right direction? Thanks! Chad -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing a checkbox
Perfect!
Thanks for all of yoru help. Chad "Dave Peterson" wrote: Rightclick on the checkbox. Look at the namebox (to the left of the formula bar) You'll see its name. If it's "Check Box 1", then you'd use: ActiveSheet.CheckBoxes("Check Box 1").Value Chad wrote: Thanks for the clarification Dave. I tried that and got an error saying: 'Unable to get the CheckBoxes property of the Worksheet class' Any suggestions? Again, I am using office 2007. Thanks again! Chad "Dave Peterson" wrote: The activeX controls and the controls from the Control toolbox toolbar are different terms for the same controls. If you used the checkbox (not textbox) from the Forms toolbar, you could have used: Sub CheckBox1_Click() If activesheet.checkboxes("CheckBox1").value = xlon Then ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub Chad wrote: I was playing around a little bit more and I used the ActiveX controls to insert a checkbox and it worked. Can someone tell me why inserting a checkbox from the control toolbar doesn't work with this code? Thanks! Chad "Chad" wrote: I believe that the checkbox is from the forms toolbar (Is Office 2007 I go under the Developer tab and then select 'Insert Control" and choose the textbox under the form controls). I have the code running under a module. The sub routine is called when the checkbox is clicked, however, regardless of whether it is checked or not, CheckBox1 is always recognized as False. Thanks again for al lo fyour help. Chad "Dave Peterson" wrote: Is this a checkbox from the Control toolbox toolbar or is this a checkbox from the Forms toolbar? If it's from the control toolbox toolbar, then is your code under the worksheet that holds that checkbox? If it's from the Forms toolbar, then the code belongs in a General module and needs to be modified. Did you allow macros to run when you opened the workbook? Chad wrote: I have been playing around with controls on excel 2007 and am getting frustrated ofver something I am sure is very simple...I simply want to perform an action when a checkbox = true. I have the following code: Sub CheckBox1_Click() If CheckBox1 = True Then ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A" End If End Sub For some reason this code does not recognize when the checkbox is true or not. can someone point me in the right direction? Thanks! Chad -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing Checkbox Names | Excel Worksheet Functions | |||
link a checkbox in a sheet to a checkbox on a userform? | Excel Programming | |||
How do I link one checkbox to update another checkbox? | Excel Programming | |||
checkbox on form reset from checkbox on sheet | Excel Programming | |||
referencing a checkbox cell address in a worksheet | Excel Programming |