Run macro when cell value changes

[JJGF]

I have check boxes down Col. A and a cell that references the check box linked cell (same cell as check box) in Col. T.

When any check box cell = True, the corresponding cell in Col. T will = 1.

I want a macro to run when any cell in col T = 1 by using Worksheet_Change(ByVal Target As Range)

[RudiS]

Hi,

See image attached.
You need to place code into the Worksheet_Change event handler that you can access by right clicking on the sheet tab and choosing View Code from the context menu.

[JJGF]

Hi,

See image attached.
You need to place code into the Worksheet_Change event handler that you can access by right clicking on the sheet tab and choosing View Code from the context menu.

Hi, I think you misunderstand, I know how to get code in the VBA. I need a solution for the problem I explained in my post.

[alansidman]

I am confused by your request in the first post. What do you want the VBA to do? You indicate that when any textbox in column A = True then Corresponding value in Column T= 1.

Then you ask

I want a macro to run when any cell in col T = 1

What do you want the macro to do? What am I missing here in your request?

[RudiS]

Hi,

In your post you say:
I want a macro to run when any cell in col T = 1 by using Worksheet_Change(ByVal Target As Range)

That is not much of a description of what you want the code to do?
All I can provide is the skeleton of the event. You will need to provide more info about what must be done if the value in column T becomes 1.

Please Login or Register  to view this content.

[JJGF]

Hi,

In your post you say:
I want a macro to run when any cell in col T = 1 by using Worksheet_Change(ByVal Target As Range)

That is not much of a description of what you want the code to do?
All I can provide is the skeleton of the event. You will need to provide more info about what must be done if the value in column T becomes 1.

Please Login or Register  to view this content.

I'll try that, brb...

[JJGF]

Hi,

In your post you say:
I want a macro to run when any cell in col T = 1 by using Worksheet_Change(ByVal Target As Range)

That is not much of a description of what you want the code to do?
All I can provide is the skeleton of the event. You will need to provide more info about what must be done if the value in column T becomes 1.

Please Login or Register  to view this content.

Ok, your code works (I put a msgbox where macro will be) but only if I manually type a 1 in a cell in Column T, I am trying to activate the macro by clicking a check box in column A which changes the value in the cell in Column T to a 1 but this by itself will not activate the macro.

Btw, the only range I need in Column T is T9:T72

[JJGF]

I am confused by your request in the first post. What do you want the VBA to do? You indicate that when any textbox in column A = True then Corresponding value in Column T= 1.

Then you ask

What do you want the macro to do? What am I missing here in your request?

Example, in Cell T17: =IF(AND(A17=TRUE,D17="NONE"),1,"")

cell A17 is a checkbox, so I want the macro to run when I click on the checkbox in A17 (changing it to True) and T17 = 1

[RudiS]

Hi,

OK...it is not "changed", as a formula is updating it. in this respect, it is the "calculate" event that must be used.
I had to use a loop to check any cell in your range if it becomes a one. Usually though, if you use controls on a sheet or a userform, the code sits under the control, similar to...If CheckBox1.Value = TRUE then MsgBox "Run the macro"

Use the following:

Please Login or Register  to view this content.

[JJGF]

Hi,

OK...it is not "changed", as a formula is updating it. in this respect, it is the "calculate" event that must be used.
I had to use a loop to check any cell in your range if it becomes a one. Usually though, if you use controls on a sheet or a userform, the code sits under the control, similar to...If CheckBox1.Value = TRUE then MsgBox "Run
the macro"

Use the following:

Please Login or Register  to view this content.

Excellent, thanks.

[RudiS]

You're welcome