View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mut[_3_] Mut[_3_] is offline
external usenet poster
 
Posts: 1
Default 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...o&userid=30633
View this thread: http://www.excelforum.com/showthread...hreadid=504768