VBA won't execute when formula changes cell value

[Intern2]

Hi all,

I'm having a hard time getting this to work;

VBA executes the code when value of a cell is "X"

When the value of a cell is changed to "x" due to a formula (=IF(A3+A5=4,"x",0)), unfortunately VBA will not be triggered unless I manually put an 'X' into the cell.

Can any one help me out with this?


the code is use:

Please Login or Register  to view this content.

[Izandol]

Formula does not raise Change event. You may use Calculate event or adapt Change event to look for changes in cells referred to by formula.

[Intern2]

Thank you for your prompt answer Izandol!

I'm kind of a noob in VBA, just started using it recently. If I understand correctly, vba won't be executed, because it doesn't see a change, a formula as not a target cell.
Cause of my lack of skill, I cant produce the answer in code myself, would you be able to help me out with it?

[AB33]

Intern2,
Please use code tags with your code as per forum's rule.

[Izandol]

I must see workbook to change the code. Calculate event has no Target parameter and so the code must test all the required formula cells, or the Change event must test input cells for changes but I do not know where they are.

[Intern2]

Intern2,
Please use code tags with your code as per forum's rule.

Ah sorry, I will look into the forum rools on how to do that!

[AB33]

Click the edit button on post #1. Then highlight the entire code, click the # sign ( # is found on quick reply menu).

[Intern2]

@AB33: done

Find the excel file attached,
The concerning sheet = sheet2 ("Needs to be sorted"),
When "X" is entered in the first column, the entire row will be cut and pasted in Sheet3 ("DOC").

[Izandol]

You may try this instead of your codes:

Please Login or Register  to view this content.

[Intern2]

Thank you soo much for your help Izandol! The code seems to work perfect!
Really appreciate it!