Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-07-2025, 04:01 AM
RobinClay RobinClay is offline Formatting dates only in Diary transcriptions Windows 10 Formatting dates only in Diary transcriptions Office 2019
Novice
Formatting dates only in Diary transcriptions
 
Join Date: Jan 2021
Posts: 9
RobinClay is on a distinguished road
Default Formatting dates only in Diary transcriptions

I am SO lucky to have a team transcribing - a month at a time - my grandmother's diaries, 1900-1977.
I send out the scans and a "blank" Word Doc with the dates formatted, so I can then just paste that month into a file for that year.
But my most prolific transcriber always sends it back as a plain .txt file.
So I format say
"Sun Jan 1 1965 Salisbury"
as Bold, size 14

Then I click on the "Format Painter" icon,
then move to


"Mon Jan 2 1967 Home"
and select that entire line.
Job done !

BUT . . I have to do that 365 (or more !) times for each year !

Would some kind soul please give me a VBA routine that would

Run through the entire file
Find every line that is empty, but is followed by a line that starts with "Mon ", "Tue ", etc
Then format that entire second line as Bold, size 14.

I can do that SORT of thing in Excel VNA, no sweat - but WORD VBA is a complete mystery !

Pretty please ?
Reply With Quote
 

Tags
formatting text, word vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Diary template RobinClay Word 0 05-05-2023 03:22 PM
Formatting th at the end of ordinal dates DBlomgren Publisher 0 01-23-2016 09:44 AM
Conditional Formatting Dates Phil H Excel 6 12-08-2014 07:42 AM
Formatting dates only in Diary transcriptions Conditional Formatting Dates jake.harris5253 Excel 1 12-06-2014 10:59 AM
Conditional Formatting with Dates namedujour Excel 1 02-21-2013 03:42 AM

Other Forums: Access Forums

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