msgbox

[Emad Sabry]

[TABLE="width: 500"]
<tbody>[TR]
[TD]row[/TD]
[TD]column A[/TD]
[TD]column B[/TD]
[TD]column C[/TD]
[TD]column D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]Emad1[/TD]
[TD]700[/TD]
[TD]600[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]Emad2[/TD]
[TD]600[/TD]
[TD]700[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3[/TD]
[TD]Emad3[/TD]
[TD]250[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

column c has a formula and also column D and they Constantly changing

I want msgbox if d1 <= C1 msgbox show title = alert - msgbox= Emad1 (the text in B1) for one time and if D1 less again the msgbox doesn't show until d1 becomes 0 msgbox show tiltle ="Emad1" -msgbox = 0 (the value of D1)

and the same thing for the other d2 <= C2 ...

and i want that for 5000 row

can that done with vpa or hard

 

[Emad Sabry]

any help ?