View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jrd269[_6_] jrd269[_6_] is offline
external usenet poster
 
Posts: 1
Default macro in vba to display autoshape


I am look to have a gradient of color displayed instead of my cell
background. Like 1-green, 2-blue and if 1.5 is entered green fading
into blue. Now I can create an autoshape that does that, and have to
manually size and place it in the correct spot. Is there any way some
VBA can muster that?
-Joe


--
jrd269
------------------------------------------------------------------------
jrd269's Profile: http://www.excelforum.com/member.php...o&userid=23815
View this thread: http://www.excelforum.com/showthread...hreadid=377185