How to Make Font Bold Using VBA (With Example)

You can use the Font.Bold property in VBA to make font in specific cells in Excel bold.

For example, you could create the following macro to make the font in cell A1 of a sheet bold:

Sub MakeFontBold()
Range("A1").Font.Bold = True
End Sub

Or you could create the following macro to make the font in each cell in the range A1:C1 bold:

Sub MakeFontBold()
Range("A1:C1").Font.Bold = True
End Sub

The following example shows how to make font bold in practice by using VBA.

Example: Make Font Bold Using VBA

Suppose we have the following dataset in Excel that contains information about basketball players on various teams:

We can create the following macro to make only the font in cell A1 bold:

Sub MakeFontBold()
Range("A1").Font.Bold = True
End Sub

When we run this macro, we receive the following output:

Notice that the font in cell A1 has been changed to bold while all other cells have remained unchanged.

If we would instead like to make each of the cells in the range A1:C1 bold, then we can create the following macro:

Sub MakeFontBold()
Range("A1:C1").Font.Bold = True
End Sub

When we run this macro, we receive the following output:

Notice that the font in each of the cells in the range A1:C1 is now bold.

Note: You can find the complete documentation for the VBA Font.Bold property here.

The following tutorials explain how to perform other common tasks in VBA: