ExcelApplication - Bold

How to implement bold , color for particular excel range.
Thanks in advance.

Here is code from my Xojo Excel 2019 book which adds four words to cells A1, A2, A3, and A4. A range of cells from A1 to A2 have the font bolded, and the colour changed to green.

Sub Pressed() Handles Pressed
  Var excel As New ExcelApplication
  excel.visible = True
  excel.Range("A1").Value = "Hello"
  excel.Range("A2").Value = "World"
  excel.Range("A3").Value = "with"
  excel.Range("A4").Value = "colour"
  excel.Range("A1:A2").Font.Bold = True //Bold
  excel.Range("A1:A2").Font.Color_ = 65280 //Green
End Sub

Here is a screen grab of the final running program in Excel 2019


1 Like