Character Substitution in Array
 

In VBA, you can use the .Characters(...).Font statement to change the Name,
FontStyle, Size, etc. of individual characters in a cell. Is there any way
to do the same with a character string in VBA without first placing it into a
cell?

Example - in the string "ABCDEFG", if I want the 'B' to be green, the 'D' to
have a font size of 12, and the 'F' to have the font name 'Symbol', I can put
the string into a cell and then set the individual characters. But can I
take the string inside VBA and do the same, without first placing it into a
cell?

--
Bill @ UAMS

Character Substitution in Array
 

I believe the answer to this one is "Sorry, no". A variable or constant in
VBA does not have the attributes available, so yes, you're going to have to
place it into a cell and do the format work at that point.

Think about it just a moment - the properties you are speaking of are
actually part of the Cell's properties, with the Characters being one of the
properties of the cell itself, and the font/color/etc of the individual
characters being a property of the .Characters in the cell.

"BillCPA" wrote:

In VBA, you can use the .Characters(...).Font statement to change the Name,
FontStyle, Size, etc. of individual characters in a cell. Is there any way
to do the same with a character string in VBA without first placing it into a
cell?

Example - in the string "ABCDEFG", if I want the 'B' to be green, the 'D' to
have a font size of 12, and the 'F' to have the font name 'Symbol', I can put
the string into a cell and then set the individual characters. But can I
take the string inside VBA and do the same, without first placing it into a
cell?

--
Bill @ UAMS