View original (French)

Make a cell bold in VBA

Solved
Kristoch91 -  
lermite222 Posted messages 9042 Status Contributor -
Hello,

I want to make a cell bold with VBA coding.
My question may seem a bit simplistic, but I can't find the code :s

Thanks in advance
Configuration: Windows 2000 Internet Explorer 6.0 Excel 2000

2 answers

  1. dePassage
     
    In Excel, there is a very interesting tool, the macro recorder.
    You perform the action you are interested in, and you get VBA code back.

    Example for bold
    You will end up with something like this 

     Range("D17").Select Selection.Font.Bold = True


    It's up to you to retrieve the instruction that interests you 

     Range("D17").Font.Bold = True
    18