VBA Cell Font – Change Bold, Italic or Underline

VBA Cell Font
  • Save

Introduction/Problem Statement

Sometimes the user needs to highlight the font to show its importance. we change the VBA Cell Font of the text to bold, italic or underline to highlight text.

Solution

VBA Cell Font  – Change to Bold

This code will change the font of Range A2 to Bold.

Change Font to Bold
  • Save

Change Font to Italic.

This code will change the font of range A4 to italic

Change Font to Italic
  • Save

Change Font to Underline.

This code will change the font of range A5 to underline.

Change Font to Underline
  • Save

Conclusion

In this blog, we have seen how to change the VBA Cell Font to bold, italic or underline using VBA in Excel. We can use the above code according to our needs.

1 Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Copy link
Powered by Social Snap