I found some Excel spreadsheets that were created by other users.
In one workbook the creator used a text box & drawing tools to create
fancy 3D text with stripes on the letters. Does anyone know which
option(s) draw diagonal stripes on letters?

I've tried highlighting the text, right-clicked, and looked at "Format
Text Effects" and "Format Shape". I've also looked at "Shape Fill"
and "Texture", but I can't find out how this text effect was created.

Is there a good way to find out what effects have been applied to
text inside a text box?

I found some Excel spreadsheets that were created by other users.
In one workbook the creator used a text box & drawing tools to create
fancy 3D text with stripes on the letters. Does anyone know which
option(s) draw diagonal stripes on letters?

I've tried highlighting the text, right-clicked, and looked at
"Format
Text Effects" and "Format Shape". I've also looked at "Shape Fill"
and "Texture", but I can't find out how this text effect was created.

Is there a good way to find out what effects have been applied to
text inside a text box?

Did you look at *Insert Wordart*?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

"GS" wrote:

Did you look at *Insert Wordart*?


I looked but found no Wordart that creates text with slanted stripes
over the font.

Does VBA have a means to inspect the object and enumerate
through the object properties, and show me what styles were
applied to the object?

"GS" wrote:

Did you look at *Insert Wordart*?


I looked but found no Wordart that creates text with slanted stripes
over the font.

Does VBA have a means to inspect the object and enumerate
through the object properties, and show me what styles were
applied to the object?

Perhaps the text was created externally and inserted as an image?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

"GS" wrote:

Perhaps the text was created externally and inserted as an image?


It's actually a font with several styles applied. If I click in the middle
of the string I can start typing. The new letters that I type retain the
same style with diagonal stripes.

"GS" wrote:

Perhaps the text was created externally and inserted as an image?


It's actually a font with several styles applied. If I click in the
middle
of the string I can start typing. The new letters that I type retain
the
same style with diagonal stripes.

What does it show for a fontname?
Are the stripes 3D effects?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

"GS" wrote:

What does it show for a fontname?
Are the stripes 3D effects?


It shows as Calibri (Body), size 40. The stripes are 2D
diagonal lines, like a pattern.

"GS" wrote

What does it show for a fontname?
Are the stripes 3D effects?


I snapped a photo and posted online he

s11.postimg.org/wjng0blk3/image.jpg

"GS" wrote

What does it show for a fontname?
Are the stripes 3D effects?


I snapped a photo and posted online he

s11.postimg.org/wjng0blk3/image.jpg

I see this font *Calibri (Body)* in MS Word not Excel. Perhaps it's
embedded?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

"GS" wrote:

I see this font *Calibri (Body)* in MS Word not Excel. Perhaps it's
embedded?


I thought that since Word and Excel are part of the same Microsoft
Office suite that they shared many of the same features. Even so,
I still can't find that stripe colored font in Word. Did you find it?

"GS" wrote:

I see this font *Calibri (Body)* in MS Word not Excel. Perhaps it's
embedded?


I thought that since Word and Excel are part of the same Microsoft
Office suite that they shared many of the same features. Even so,
I still can't find that stripe colored font in Word. Did you find
it?

I did not find it. Perhaps there's an addin that was used?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

"Robert Crandal" wrote in message
"GS" wrote

What does it show for a fontname?
Are the stripes 3D effects?


I snapped a photo and posted online he

s11.postimg.org/wjng0blk3/image.jpg

It's Wordart direct from the 2013 Ribbon. It includes a patterned texteffect
fill which was in the 2003 UI but removed in the 2007 UI. The code for
patterns is still the same but exactly what to apply it to has changed,
would need to poke around a bit.

Regards,
Peter T

"Robert Crandal" wrote in message
"GS" wrote

What does it show for a fontname?
Are the stripes 3D effects?


I snapped a photo and posted online he

s11.postimg.org/wjng0blk3/image.jpg

It's Wordart direct from the 2013 Ribbon. It includes a patterned
texteffect fill which was in the 2003 UI but removed in the 2007 UI.
The code for patterns is still the same but exactly what to apply it
to has changed, would need to poke around a bit.

Regards,
Peter T

Thanks for ringing in! Found it in 2003...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

"Robert Crandal" wrote in message
"GS" wrote

What does it show for a fontname?
Are the stripes 3D effects?


I snapped a photo and posted online he

s11.postimg.org/wjng0blk3/image.jpg

It's Wordart direct from the 2013 Ribbon. It includes a patterned
texteffect fill which was in the 2003 UI but removed in the 2007 UI.
The code for patterns is still the same but exactly what to apply it
to has changed, would need to poke around a bit.

Regards,
Peter T

Also found it in 2010...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

"GS" wrote:

Also found it in 2010...


I'm using Excel 2007 at home. 8(

"Robert Crandal" wrote in message
"GS" wrote:

Also found it in 2010...

Do you mean the UI to apply a patterned fill as the texteffect?



I'm using Excel 2007 at home. 8(

As I said, just need to poke around a bit :)

This seems to work in 2007 where the selection is the text in some Wordart

Set sr = Selection.ShapeRange
Set tf = sr.TextFrame2
Set tr = tf.TextRange
Set f = tr.Characters.Font.Fill
f.Patterned msoPatternLightDownwardDiagonal
f.ForeColor.RGB = RGB(32, 66, 104)
f.BackColor.RGB = RGB(214, 234, 246)

could do individual characters, eg .Characters(6, 5).etc

shadow etc whatever else

Regards,
Peter T

Do you mean the UI to apply a patterned fill as the texteffect?

Yes, I was able to duplicate Robert's text in 2003/2010 since both
support pattern effects!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

"GS" wrote in message
Do you mean the UI to apply a patterned fill as the texteffect?

Yes, I was able to duplicate Robert's text in 2003/2010 since both support
pattern effects!

Ah so it is, 2013 too albeit in a different way. 2007 also supports patterns
but not from the UI, can be replicated with code though.

Regards,
Peter T

"GS" wrote in message
Do you mean the UI to apply a patterned fill as the texteffect?

Yes, I was able to duplicate Robert's text in 2003/2010 since both
support pattern effects!

Ah so it is, 2013 too albeit in a different way. 2007 also supports
patterns but not from the UI, can be replicated with code though.

Regards,
Peter T

Yes, I saw your code for that, ..nice and simple!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion