View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Macdonald David Macdonald is offline
external usenet poster
 
Posts: 26
Default single colour system for textboxes

As far as I can see, when playing with textboxes in VBA there are three
different ways to set the colour of a characteristic: RGB, SchemeColor or
ColorIndex.
BUT they aren't interchangeable. Some properties prefer one command (if you
record a macro) but will accept another.
To set the border colour or fill colour you can use RGB references
RGB(255, 255, 255)
or scheme colours
SchemeColor = 65
but to set the font colour you can only use the colour index
ColorIndex = 2

The above are 3 different ways to say WHITE.
Is there a single form that will always work ? Doesn't look that way to me
but hopefully the grand masters out there know a way.

--
WinXP - Office2003 (Italian)