<div>
Thanks, so I assume to make sure using blue, this should be added always to the workbook<br />
<br />
&nbsp; &nbsp; ActiveWorkbook.ResetColors<wbr /><br />
<br />
and after selecting the blue from the palette, which will be always on the same place in this way<br />
<br />
&nbsp; &nbsp; Selection.Font.ColorIndex = 5<br />
<br />

</div>


Thanks, so I assume to make sure using blue, this should be added always to the workbook

    ActiveWorkbook.ResetColors

and after selecting the blue from the palette, which will be always on the same place in this way

    Selection.Font.ColorIndex = 5



<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
Could you propose a reliable way of using VBA commands about font coloring?<br />
<br />
I am aware two versions for example to blue<br />
Worksheets(&quot;Sheet1&quot;).Range<wbr />(&quot;A1&quot;).Fon<wbr />t.ColorInd<wbr />ex = 6 - this using the place of color from pallet<br />
Worksheets(&quot;Sheet1&quot;).Range<wbr />(&quot;A1&quot;).Fon<wbr />t.Color = 16711680 - this would set the blue color, but as I perceive at default color pallet settings, it became yellow :-)<br />
<br />
Is there maybe chance to use RGB values in VBA?<br />
<br />
thanks, 
</div>
</div>


Dear Experts,

Could you propose a reliable way of using VBA commands about font coloring?

I am aware two versions for example to blue
Worksheets("Sheet1").Range("A1").Font.ColorIndex = 6 - this using the place of color from pallet
Worksheets("Sheet1").Range("A1").Font.Color = 16711680 - this would set the blue color, but as I perceive at default color pallet settings, it became yellow :-)

Is there maybe chance to use RGB values in VBA?

thanks, 

VBA Excel 2000 - Basic colors handling

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.