Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to multiply all cells in array by factor | Excel Discussion (Misc queries) | |||
Transpose words and numbers into array of different proportions | Excel Discussion (Misc queries) | |||
Wildcard Character in an Array Formula | Excel Discussion (Misc queries) | |||
how do I make single character as a variable in an array | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |