Excel VBA Basics #18 – Change the Font Type, Size etc using VBA!




About this tutorial:

Video duration: 5:48
In this lesson, we learn about the .FONT properties that can be easily manipulated in your Macro or code. Check it out!

Get My Bestselling Excel VBA Courses:
Excel VBA Essentials Course:
Control Websites With Excel VBA:
Speed Up Code With VBA Arrays:
Create Your Own Functions/Addins:
Fill PDFs/Forms with Excel VBA:
Excel VBA Barcode Lookup System & Inventory Projects:
Instantly Secure Excel Files; Transform…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

9 thoughts on “Excel VBA Basics #18 – Change the Font Type, Size etc using VBA!

    anncute1000

    (November 9, 2019 - 5:21 pm)

    Thanks for this.. how about if i have a column (m20:n84) in excel 2016 font style was set to windings 2 but i want the n/a to appear in arial Narrow. I pull the data (using vlookup) from another sheet to create a form that show checkbox and n/a. Can you please help me how to show the n/a as arial narrow font and not as windings symbol. Thank you in advance

    Luis dso

    (November 9, 2019 - 5:21 pm)

    thank you so much for taking the time to do this video

    Mára

    (November 9, 2019 - 5:21 pm)

    What if I have multiple lines in one cell (char(10)) and I want to format these lines differently? And even the lines are lenght variable?

    ExcelVbaIsFun

    (November 9, 2019 - 5:21 pm)

    Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

    Zaigham uddin Farooqui

    (November 9, 2019 - 5:21 pm)

    Thanks.

    Daniel Carreras

    (November 9, 2019 - 5:21 pm)

    Thank you

    Jan Bolhuis

    (November 9, 2019 - 5:21 pm)

    Thanks!

    ExcelIsFun

    (November 9, 2019 - 5:21 pm)

    Thanks!

    krn14242

    (November 9, 2019 - 5:21 pm)

    Thanks Daniel

Leave a Reply

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