Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 12-16-2022, 02:40 PM
Keithronaut Keithronaut is offline VBA Code to turn all text in a document black based on font, size, or other attributes Windows 11 VBA Code to turn all text in a document black based on font, size, or other attributes Office 2021
Novice
VBA Code to turn all text in a document black based on font, size, or other attributes
 
Join Date: Dec 2022
Posts: 5
Keithronaut is on a distinguished road
Default

Quote:
Originally Posted by ChrisGreaves View Post
Hello Keith. This was my business back in the 90s for multiple documents from multiple sources.
All "document cleansing" is based on locating specific items and substituting items with (usually) different characteristics, all the way from text, fonts, sequence numbering and WP5.1 document tables (built with those weird graphic characters) with MSWord tables.


I found it expedient to write a single find-and-replace macro and then feed it the input and output characteristics from a table of rules which drove the whole process. I use the same procedure to this day.


If you anticipate repeated use of find-and-replace code to change numerous items and/or characteristics, please let me know and I will make my code available to you.
Cheers, Chris
Hi Chris, thank you for the response. If it's not too much trouble I would love just a simple code to find all of the 11.5 pt. Calibri font within an entire Word Document and automatically turn it black. I'm new to a lot of the VBA coding and all of my attempts so far are returning errors. I certainly appreciate your response!
Reply With Quote
 

Tags
font color



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Code to turn all text in a document black based on font, size, or other attributes Using custom style instead of inserting font attributes manually in VBA code laith93 Word VBA 2 11-07-2021 12:52 AM
Duplicating Ranges and changing Font Attributes CharlieM Word VBA 3 08-10-2021 04:44 AM
VBA Code to turn all text in a document black based on font, size, or other attributes Merging two Word documents: 2nd document not maintaining original font type and font size Swarup Word 31 08-28-2018 06:55 PM
Locking Header/Footer on Document but still be able to edit body text (size, font, bold, etc) Porkie96 Word 1 06-21-2018 01:56 PM
VBA Code to turn all text in a document black based on font, size, or other attributes Character based Search and Replace font size anacond11 Word 2 08-08-2013 08:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:25 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