I know very little about vba. But am trying to tweak a macro for visio.
I want to tweak text but can't find anything on this:
' set font size and color, text alignment, border, fill and shadow
.Cells("Char.Size").Formula = "10 pt"
.Cells("Char.Color").Formula = 0 ' black
.Cells("Para.HorzAlign") = 0 ' left justify
.Cells("LinePattern").Formula = 0 ' none
.Cells("FillPattern").Formula = 0 ' none
.Cells("ShdwPattern").Formula = 0 ' none
1) Is there a table that lists what numbers to use to change HorizAlign to get centered?
2) What if I wanted to bold the text?
3) there's a line after these for text (it's a table of contents): .Text = arrPages(i, 1) & vbTab & CInt(arrPages(i, 2))
I'd love for the space between the page name and page number to be dotted like: Licenses.. . . . . . . .3
Do you know how I could get that?
Any idea why I can't find much about this on the web? I was googling cells syntax vba and pasting these lines into google. Didn't come up with anything.