Thread: Changing the Colour of an Auto Shape (Line)
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
d.i.barr[_9_] d.i.barr[_9_] is offline
external usenet poster
  
Posts: 1
Default Changing the Colour of an Auto Shape (Line)

Thanks bhofsetz and K Dales for the response, that works a treat.
Bhofsetz, the Case statement does make a lot more sense. Have you an
idea how I would make the values of "Color" non-case sensitive? Tha
is, to work with BLUE or Blue or blue or bLue etc without listing the
all seperately in the Case statement? Thanks in advance

--
d.i.bar
-----------------------------------------------------------------------
d.i.barr's Profile: http://www.excelforum.com/member.php...fo&userid=1552
View this thread: http://www.excelforum.com/showthread.php?threadid=38126

Reply With QuoteReply With Quote