RGB

P

phil

I am using SetFormula to set the colour of some text with
the string "RGB(10,20,30)". When run on a machine in
Sweden this crashes as the comma represents a decimal
point in their settings. I have found that "RGB(10;20;30)"
works on these systems but fails on mine. Is there a way
in code of looking up in the system settings which
character is used for a delimeter and which is used for a
decimal point ? Or is there a way I can avoid using the
RGB in SetFormula ? If I call SetCharProps
(visCharacterColor, colour) it wants a pallette index
number which I don't have as I am using colours which are
not part of the limited set but are user customisable.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Permanently change RGB values of font colour table 1
Excel does not accept text format! 0
single colour system for textboxes 1
RGB colours settings have changed 2
Creating a variable based on multiple cells 1
Sub projects added as read only in Master file which are saved on sharepoint 1
Duplication Macro & Macro crashing Word 0
Setting cell colors using RGB( ) function 1

Top