| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a Macro to enable a check box based on the content of a c
I want to be able to have a check appear in the box if I have an amount 0.
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a Macro to enable a check box based on the content of a c
What changes the amount - someone editing the cell with the amount?
right click on the sheet tab and select view code. Private Sub Worksheet_Change(ByVal Target As Range) if Target.Address = "$B$9" then If Target.Value 0 then me.checkbox1.Value = True else me.checkbox1.Value = False end if End if end sub -- Regards, Tom Ogilvy "Nausett" wrote: I want to be able to have a check appear in the box if I have an amount 0. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a Macro to enable a check box based on the content of
How do I get Excel the Checkbox to recognize the new Macro?
"Tom Ogilvy" wrote: What changes the amount - someone editing the cell with the amount? right click on the sheet tab and select view code. Private Sub Worksheet_Change(ByVal Target As Range) if Target.Address = "$B$9" then If Target.Value 0 then me.checkbox1.Value = True else me.checkbox1.Value = False end if End if end sub -- Regards, Tom Ogilvy "Nausett" wrote: I want to be able to have a check appear in the box if I have an amount 0. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a Macro to enable a check box based on the content of
The checkbox is a passive victim. Given the assumptions I made, if you have
a checkbox named checkbox1 (from the control toolbox toolbar) and it is located on the sheet with the code, and you have a cell B9, and with the code in the sheet module as I described, you change the value of B9 to 3 (as an example), checkbox1 should get checked. -- Regards, Tom Ogilvy "Nausett" wrote: How do I get Excel the Checkbox to recognize the new Macro? "Tom Ogilvy" wrote: What changes the amount - someone editing the cell with the amount? right click on the sheet tab and select view code. Private Sub Worksheet_Change(ByVal Target As Range) if Target.Address = "$B$9" then If Target.Value 0 then me.checkbox1.Value = True else me.checkbox1.Value = False end if End if end sub -- Regards, Tom Ogilvy "Nausett" wrote: I want to be able to have a check appear in the box if I have an amount 0. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a Macro to enable a check box based on the content of
I'm getting a Compile Error: Method or Data Member Not Found. Am I doing
something wrong? Thanks, "Tom Ogilvy" wrote: The checkbox is a passive victim. Given the assumptions I made, if you have a checkbox named checkbox1 (from the control toolbox toolbar) and it is located on the sheet with the code, and you have a cell B9, and with the code in the sheet module as I described, you change the value of B9 to 3 (as an example), checkbox1 should get checked. -- Regards, Tom Ogilvy "Nausett" wrote: How do I get Excel the Checkbox to recognize the new Macro? "Tom Ogilvy" wrote: What changes the amount - someone editing the cell with the amount? right click on the sheet tab and select view code. Private Sub Worksheet_Change(ByVal Target As Range) if Target.Address = "$B$9" then If Target.Value 0 then me.checkbox1.Value = True else me.checkbox1.Value = False end if End if end sub -- Regards, Tom Ogilvy "Nausett" wrote: I want to be able to have a check appear in the box if I have an amount 0. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a Macro to enable a check box based on the content of
Highly likely that you are doing something wrong. I put a checkbox on my
worksheet and named it Checkbox1. I then pasted in the code from the email into the sheet module for that worksheet. I entered a 3 in B9, the checkbox was checked. I entered a 0 in B9,. the checkbox was unchecked. -- Regards, Tom Ogilvy "Nausett" wrote in message ... I'm getting a Compile Error: Method or Data Member Not Found. Am I doing something wrong? Thanks, "Tom Ogilvy" wrote: The checkbox is a passive victim. Given the assumptions I made, if you have a checkbox named checkbox1 (from the control toolbox toolbar) and it is located on the sheet with the code, and you have a cell B9, and with the code in the sheet module as I described, you change the value of B9 to 3 (as an example), checkbox1 should get checked. -- Regards, Tom Ogilvy "Nausett" wrote: How do I get Excel the Checkbox to recognize the new Macro? "Tom Ogilvy" wrote: What changes the amount - someone editing the cell with the amount? right click on the sheet tab and select view code. Private Sub Worksheet_Change(ByVal Target As Range) if Target.Address = "$B$9" then If Target.Value 0 then me.checkbox1.Value = True else me.checkbox1.Value = False end if End if end sub -- Regards, Tom Ogilvy "Nausett" wrote: I want to be able to have a check appear in the box if I have an amount 0. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change a cell color based on its content using macro? | New Users to Excel | |||
| Check cells content based on a table | Excel Discussion (Misc queries) | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| Macro to highlight cells based on content | Excel Worksheet Functions | |||
| How to check a cell for content before running macro. | Excel Programming | |||
Hybrid Mode
