Automatic macro delay

Givec

New Member
Joined
Jun 20, 2018
Messages
4
Hello,
I have column AA & AC where some values shall be changed.
How to make automatic macro after values changing in some cell AA and AC or vice verse?
I have macro automatically run when values is a change in one cell.
I need macro where running will start after the value changing in the second cell.
Thanks in advance for the help.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
You want a script to automatically run when you change a value in any cell in column AA or Column AC.

What do you want to happen when you change a value in one of these columns?
And these changes must happen when you manually change a value.
Not as the result of a formula changing a value.
 
Upvote 0
Hello,
I must change the value in AA25 and after in AC25.
I want to run a macro automatically after changing the value in AC25.
The same automatically shall be when I change the value in AC25 and after in AA25.
Thanks
 
Upvote 0
So when you change any value in AA25 and after
And when you change any value in AC25 and after.

You said:
I want to run a macro automatically after changing the value in AC25.

What macro do you want to run?

What do you want to happen when you change a value in AA27
 
Upvote 0
If I change manually the value in AA25, the value must be changed in AC25 manually, (after a macro run automatically).
If I change manually the value in AA27, the value must be changed in AC27 manually, (after a macro run automatically).
If I change manually the value in AC328, the value must be changed in AA328 manually (after a macro run automatically).
Changing must be done in the same row and after changing, the macro can be run automatically.
For example: Changing in AA25 and after in AC27 not allowed.
 
Upvote 0
Are you saying if you change the value in AA25 to George You want the value in AC25 to be George
 
Upvote 0
I now think you mean if you change a value in Column AA
And then change a value in column AC

You want some script to run.

I do not believe there is a way to do that.

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.
 
Upvote 0
Hi,
Thanks of lot for your effort.

FYI if the value in AA25=George, the value in AC25 does not have to be the same in AC25 (can be John) or if AA25=1865, value AC25 can be 3568.
 
Upvote 0

Forum statistics

Threads
1,214,583
Messages
6,120,378
Members
448,955
Latest member
BatCoder

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top