Category Archives: VBA

VBA – Newline Character

In VBA, there is 3 types of Newline characters.

  • vbCr – Carriage Return CR
  • vbLf – Line Feed LF
  • vbCrLf – Carriage Return CR + Line Feed LF

Continue reading VBA – Newline Character

VBA – Substring Function

VBA is a very good tool to manage data. I always write some mini VBA programs to manipulate database data and create SQLs. Apart from programming, it also gives me some valuable memories with Tinyan

Let’s back to the topic. In VBA, we use Mid() to substring. Continue reading VBA – Substring Function