Run Macro if text added to a cell that contains a number

[brumby]

Hi all,

Ive managed to get work worksheet to only calculate a cell if text is added. This allows me to plot a suppliers delivery and only consider it once I add "- arrived " eg below

A1 = 1000 / AO1 = 0 ( Using the following formula - =IF(COUNTIF(A1,"*ar*")=0,0,SUMPRODUCT(IF(ISERROR(SUBSTITUTE(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",100)),{1,2,3,4,5,6,7,8,9,10}*100-99,100)),",","")*1),0,SUBSTITUTE(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",100)),{1,2,3,4,5,6,7,8,9,10}*100-99,100)),",","")*1)))

When I update A1 and change to "1000 - arrived" the above formula changes cell AO1 to 1000

I would like if possible for this to also trigger a specific Macro, so only run when "*ar*" is added to the cell.

Is this possible?

Many Thanks!!!

 

[brumby]

Hi all,

Ive managed to get work worksheet to only calculate a cell if text is added. This allows me to plot a suppliers delivery and only consider it once I add "- arrived " eg below

A1 = 1000 / AO1 = 0 ( Using the following formula - =IF(COUNTIF(A1,"*ar*")=0,0,SUMPRODUCT(IF(ISERROR(SUBSTITUTE(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",100)),{1,2,3,4,5,6,7,8,9,10}*100-99,100)),",","")*1),0,SUBSTITUTE(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",100)),{1,2,3,4,5,6,7,8,9,10}*100-99,100)),",","")*1)))

When I update A1 and change to "1000 - arrived" the above formula changes cell AO1 to 1000

I would like if possible for this to also trigger a specific Macro, so only run when "*ar*" is added to the cell.

Is this possible?

Many Thanks!!!