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

vba insert columnvba output to text fileinteger in vbaexcel checkbox macrosort vba excelmacros for beginnersadodb recordset vba excelvlookup function tutorialvba quick referenceexcel select worksheetgoto statement in vbadrop down lists in excel 2007vba msgbox variableexcel vba commandsexcel vba click buttonhow to extend columns in excelvba for excel tutorialvba copy from another workbookexcel loop through rowsaccess vba runsqlconnect excel to sql databaseinterview questions for freshers with answerssql tutorials for beginnerstask tracking template excelsyntax excelexcel vba deleteexcel password protection removalcrlf vbapassword vbapivot table formulas excel 2007vba worksheets rangeunlock excel file with passwordhide formulas in excel 2007functions in excel vbaword dashboard templatevba worksheet cellsexcel access vbavba excel tutorialexcel consolidation tutorialhow to create a worksheet in excel 2007find duplicates in excel 2013excel nested ifsexcel vba copy sheet to another workbookvba as rangeexecutive dashboard templatesexcel worksheet lockedexcel password protect workbookexcel how to hide columnsaverage function in excel 2013schedule in excel templateshow hidden tabs in excelexcel vba countifpowerpoint donut charttemplate excel project timelinevba find duplicatesmeaning of offset in hindihow to delete empty rowsexcel chart vbamsgbox inputcomplex macros in excelhow to adjust column width in excelvb define arraylookup on excelsas beginnerworkbooks.savehow to use if formula in excel 2007compare dates vbaexcel vba continue forsql queries interview questions and answers pdf for freshersvba combobox excelmacro excel definitionvlookup yes nouserform design