Change Font to Bold in Excel VBA

Home/Excel VBA/Change Font to Bold in Excel VBA


Some ties we need to change highlight the font to show its importance. We Change Font to Bold or change the background color or font color in Excel VBA, to highlight the text or some numbers. So that reader can easily recognize and look into that.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

Change Font to Bold in Excel VBA – Solution:

Delete Worksheet in Excel VBA
We can change the font to Bold by using Font.Bold Property of a Range/Cell in Excel using VBA.

Change Font to Bold in Excel VBA – Examples:

The following examples will show you how to change the font to bold in Excel using VBA.

'In this Example I am changing the Range B4 Font to Bold
Sub sbChangeFontToBold()
'Using Cell Object
Cells(4, 2).Font.Bold = True
'Using Range Object
Range("B4").Font.Bold = True
End Sub

When we want to highlight some text in the Excel, we alsoe consider changing the Fornt and Background Colors. We use ColorIndex or RGB format of Colors to apply the color for both Font and Background . You can learn more here:

Also find related example to change font Color in Excel using VBA
In this topic we will see how change the font color in Excel VBA. Again, we change the font color in excel while generating the reports. We may want to highlight the font in red if the values are negative, in green if the values are positive. Or we may change font colors and sizes for headings. etc…

You can find multiple examples on changing the font colors in Excel using VBA

Find the related example to change the background color in Excel using VBA:
It is an interesting feature in excel, we can change background color of Cell, Range in Excel VBA. Specially, while preparing reports or dashboards, we change the backgrounds to make it clean and get the professional look to our projects.

You can find multiple examples on changing the Background colors in Excel using VBA.

By |February 10th, 2013|Excel VBA|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment

Related pages

excel macro close excelmicrosoft excel macro examplesadding macro to excelexcel if clausesorting vbacheck activexmacro for comparing two columns in excelwhere is chart wizard in exceladvantages microsoft excelvba call functionvba code wordexcel vlookup examplecustom messageboxexample of pivot table in excel 2007advanced filter excelexcel if statement blankvba macro wordexcel 2010 vlookup tutorialms excel vlookup examplemsgbox macroformula replace excelcylinder chart in excelexcel 2010 lookup functionformula for adding columns in excelusing multiple if statements in excelexcel vba inputhow to protect excel sheet with password 2007excel vba activecell.addressword templates for meeting minutesexcel checkbox valuespreadsheet sort functionwriting excel macros for beginnerscountif excelhow to add developer tab to the ribbonexcel monthly schedule templatepowerpivot excel 2010 tutorialexcel count filled cellsfilter in vbacell color vbaselect range in vbabutton vbaexcel concanatehow to unlock protected excel sheet without passwordexcel 2010 hyperlinks change to local pathuseful vbanested if in vbscriptonline unprotect excel sheetvba select folderproject timetable template excelhow to access vba in excel 2007excel joining cellslearn excel vba step by stepexcel spreadsheet password protectsendmail syntaxexcel advanced filter wildcardexcel vba userform combobox additemexcel macro while loopvb6 file existsdata mining add insms excel interview questions and answershow to use nested if statements in excelvba copyfilehow to append excel filesproject management spreadsheet excel templatemicrosoft excel basics tutorialvba workbookvba yes novbscript excelsortable columns excelvba protect workbook with passwordvb color codes listvba excel tablesample charts in exceldelete duplicate dataexcel nested if statement exampleshow to create macro button in excel