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 vba switch caseopen and activate workbook vbavba loops for dummieshow to add developer tab in excel 2013ms excel substituteinsert a checkbox in excel 2007how to sort numbers in ascending order in excelexport excel to txtshortcut key for next sheet in excelvb6 delete fileunprotect excel sheet onlinestep by step vlookupisna excelpowerpoint project status dashboard templateexcel sql commandsexcel project timeline chartdrop down list excel 2007vba do until loopvlookup on excelunlock vbavba timer examplestring vbaadding lines to excel spreadsheetexcel widget dashboardstop vbahow to merge sheets in excelcellcolorexcel pivot table referenceunlock excel without passwordvba update sqlvlookup vba codemacro worksheetworksheets vba excelexcel 2013 data validationdelete excel worksheetshortcut to close excel fileproject charter sample templateworksheetfunction sumoffset function in excelinsert a check boxsql compare operatorsvba excel columnscopy excel worksheethow to delete blank columns in excelquery sql database from excelexcel vba integerunhide worksheetsworksheetfunction.vlookup vbacosting templatefso vbamessage box vbsexcel macro create folderhow to use datevalue function in excelvba array excelexcel how to delete blank rowsmerge cell excelhow to multiply a column in excelexcel vba data validation listlistbox selectionchart types in excelhow to lock an excel documentunprotect an excel worksheethow to enable macro in excelddl example sqlstacked pie chart exceljob costing excel templateexcel macro change cell coloroffset vba excelexcel formula and operatorvba excel commenthow to draw control chart in excel 2007ms excel developer tabclose msgbox vbadeclaring array vbavba application displayalertsvba getsaveasfilename