Vbcrlf is a combination of the two actions explained above: the Carriage Return ( VbCr) that moves the cursor back to the beginning of the line and the Line feed ( VbLf) that moves the cursor position down one line.

Move the paper up by the width of one line.

On a typewriter, this is done by moving the roll which carries the paper (the “carriage”) back to the right.

Move the typing head back to the left.

There are two distinct actions needed to start a new line of text: To better understand Vbcrlf, you need to recall the days of old manual typewriters – if you’re old enough to remember – to get the origins of this. Vbcrlf stands for “Visual Basic Carriage Return Line Feed.” It is a VBA constant for the carriage return and line feed characters. In this article, you will learn how to use the Vbcrlf in VBA. For example, to go to a next line, you just have to press the ENTER key. For a specialized word processing software like MS Word, this is easy. To facilitate the reading of a messages by users or readers – especially long messages – it is necessary to format it conveniently through new lines, alignment, new paragraphs, etc.

Visual basic for excel array