Dynamic AutoShape


Dear all,
I have sheet1 that contains Data in column A and B.

A B
5 3
7 10
4 4

In column C, I create Autoshape-BlockArrow-RightArrow that indicate
flow data in a row.

If B is greater than A, so Right Arrow could be rotate 315 degree.
If B is less than A, so Right Arrow could be rotate 45 degree.
If B is equal to A, so Right Arrow not rotated.

I need VBA code doing this 'dynamic right arrow'...
Thanks for your help...

Regards,
Mut


--
Mut
------------------------------------------------------------------------
Mut's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30633
View this thread: http://www.excelforum.com/showthread.php?threadid=504768

.