Auto call macro without pressing button

Dear Experts

Please help!!!

I need to auto call macro without pressing button.
example If user enters time in cell range("M4:M200")
P4:P200 (=IF(M4="","",1)
If P4:P200 "1" Call add_timepunch (macro)

I have this below code

Please Login or Register  to view this content.

Hi,

You forget to put your code inside code tag, please do so.

Sub Worksheet_Change(ByVal Target As Range) is only triggered if changes is performed by hand (by manually typing in the target range), it will not triggered if the changes is caused by macro or as return value of function in target cell.

So, you put formula in P4:P200 : =IF(M4="","",1), and when you type something in column M, the value in P4:P200 is also changed, but the changes is not by manual typing in P4:P200, but as a result of the function, that's why the Worksheet_Change() event is not triggered.

The remedy for the situation is, instead tracking of P4:P200, you should use M4:M200 instead (the range that its value is changed by manually typing) :

Please Login or Register  to view this content.

Regards

Yes, I know that you want to track any cell changes on range P4:P200, but as I said earlier that if the changes is performed by function of this range (the return value of function is changed), then the Worksheet_Change() event is not triggered.
Have you tried the code that I provided in #2 ? Does it work ? If not, please tell in what behaviour it doesn't work, so I can amend the code.


Regards