In VBA, there is 3 types of Newline characters.
- vbCr – Carriage Return CR
- vbLf – Line Feed LF
- vbCrLf – Carriage Return CR + Line Feed LF
Tag Archives: VBA
Rails – Preset Data in Database by Seed Fu
I want to have a country field in my User model and i want it to be a selection list instead of free text input. So i plan to have a countries table which contains all the possible options as of the ISO 3166 country list. Continue reading Rails – Preset Data in Database by Seed Fu
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
Eureka! 