format text with VBA

trevorc · #2 05-26-2020, 10:27 PM

Couldn't wait, found a workaround that works for me...

Code:

           With ActiveCell
            
            
            
            fst = InStr(8, ActiveCell, ":")
            
'Format INV BOLD
.Characters(fst + 3, ActiveCell.Characters.Count - 4).Font.Bold = True
.Characters(fst + 7, ActiveCell.Characters.Count).Font.Bold = False
'Format INV number size
.Characters(fst + 3, ActiveCell.Characters.Count - 4).Font.Size = 20
.Characters(fst + 7, ActiveCell.Characters.Count).Font.Size = 11

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find text, format part of text in italic	d4okeefe	Word VBA	18	06-30-2022 11:35 PM
Macro to find text in between two characters and then format selected text?	qcom	Word	5	02-19-2015 11:23 PM
How to format text in a CELL?	Learner7	Excel	3	08-06-2012 03:52 AM
text format	bkcell	Word	2	07-15-2011 04:59 PM
Objective: Automatically export email text,attachment text to DB friendly format	SilentLee	Outlook	0	11-14-2010 02:45 PM