Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 161
Default Text with stripes?

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?



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Text with stripes?

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
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 161
Default Text with stripes?

"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?



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Text with stripes?

"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
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 161
Default Text with 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.





  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Text with 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using TEXT and &TEXT - display numbers with commas, underline text Gary Excel Discussion (Misc queries) 3 May 5th 23 03:46 AM
Charting 'stripes' of data from within a table? Jeff Fry Charts and Charting in Excel 1 February 20th 08 06:41 PM
Coloured horizontal stripes robotmannick Charts and Charting in Excel 2 June 21st 06 01:00 AM
tip of the day should be relevant, not vacuous: stripes & plaids? grump88 Excel Discussion (Misc queries) 0 May 12th 05 06:51 PM
extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' Dan E[_2_] Excel Programming 4 July 30th 03 06:43 PM


All times are GMT +1. The time now is 10:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"