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

Change your else if from Or to And

ElseIf Color < "GREEN" Or Color < "BLUE" Then

to

ElseIf Color < "GREEN" And Color < "BLUE" Then

HTH


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=381268

Reply With QuoteReply With Quote