View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Thunder[_2_] Thunder[_2_] is offline
external usenet poster
 
Posts: 2
Default Can I create a Custom Colour?


"Co-op Bank" ha scritto nel messaggio
...
Hello, I need to colour a cell using VBA but the standard color index
property only gives me 1 shade of yellow to choose from, is there anyway I
can use a spare color index property and make that the color I need
somehow?
or any other way?

Thanks
Brian
Manchester, England


If using RGB color?
For example: ActiveCell.Interior.Color = RGB(0, 0, 255)

Thunder