Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-06-2013, 05:01 PM
Jennifer Murphy's Avatar
Jennifer Murphy Jennifer Murphy is offline Testing for a printable character Windows XP Testing for a printable character Office 2007
Competent Performer
Testing for a printable character
 
Join Date: Aug 2011
Location: Silicon Valley
Posts: 234
Jennifer Murphy is on a distinguished road
Default Testing for a printable character

Is there a good way to test whether a character is one that would be displayed on screen and printed?

I'm working on a little macro to change each character in a string of text to a random color according to some theme. For the Christmas theme, each letter would be changed to red or green. For Halloween, orange or black.

The macro limits the number of consecutive characters that can be assigned the same color. The problem is that non-printing characters, like space and tab, defeat the limit.



If I set the limit to 3, then the macro will not allow more than three consecutive characters to be assigned the same color. But it will happily allow three characters on either side of a space to all be red as long as the space is green. But since the space is non-printing, it looks like there are 6 red characters.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Printable Area issues zaineyma Word 3 12-12-2012 09:11 AM
Testing for a printable character HELP/ADVICE NEEDED. Testing Excel Accessibility guidelines cmc89 Excel 1 03-29-2012 03:41 PM
Printable Entry Form eJames Excel 1 01-07-2010 09:50 AM
Making template that is not printable Askaleto Word 0 10-14-2009 11:45 AM
Defining Printable Areas OfficeUser00939 Word 5 06-29-2009 09:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft