format text with VBA

trevorc · #1 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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