View Single Post
 
Old 06-17-2015, 10:18 AM
muiy muiy is offline Windows 8 Office 2013
Novice
 
Join Date: Jan 2015
Posts: 7
muiy is on a distinguished road
Default Macro to capitalize first letter after timecode + tab

Hello all,

I am looking to write a macro where when I run it, it will capitalize the first letter of any line that has a timecode and then is indented (via TAB). The format of the timecode is this:


0:53:04.9 so I wish the “s” in that first word of this line will get capitalized when I run the new macro I'm trying to create.

(Where the gap between the 9 and the s is a tab-created gap in Word)

I found a way to capitalize the first letter after a colon using the macro I found on this site:

https://cybertext.wordpress.com/2011...to-upper-case/

While searching for a macro that does that I came across several searches that ended on this forum, so I was hoping I could find some help here. I am unfamiliar with VBA at the moment so writing it myself seems challenging. Just looking at the other macro, I'm guessing I need to change the .Text part of the macro to numbers 0-9, and somewhere in the macro I need to specify the tab. Or maybe it should be written from scratch.

Thanks for any help.
Reply With Quote