Thread: [Solved] format text with VBA
View Single Post
 
Old 05-26-2020, 10:27 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
  
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default
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
Reply With Quote