Make a cell bold in VBA
Solved
Kristoch91
-
lermite222 Posted messages 9042 Status Contributeur -
lermite222 Posted messages 9042 Status Contributeur -
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
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 réponses
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
It's up to you to retrieve the instruction that interests you
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
