Thread: retrun an RGB value to a specified cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
a1k1do via OfficeKB.com a1k1do via OfficeKB.com is offline
external usenet poster
  
Posts: 3
Default retrun an RGB value to a specified cell
thanks Peter

Peter T wrote:
or simply

strHex = "FFFF00"
lngClr = CLng("&H" & strHex)

Regards,
Peter T

'Requires a reference (in the VBE) to the AnalysisToolPak (atpvbaen.xls)
Sub ColorMyCell()
[quoted text clipped - 14 lines]

-snip-

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/201005/1

Reply With QuoteReply With Quote