On Monday, April 20, 2020 at 4:45:03 PM UTC-4, Claus Busch wrote:
Hi Desmond,

Am Mon, 20 Apr 2020 12:03:08 -0700 (PDT) schrieb Desmond Walsh:

Sub testz()
Dim line As String
Debug.Print "Hello World"
line = "Hello World"
Debug.Print line
Debug.Print "Hello"; Tab(10); "World"
line = "Hello; Tab(10); World"
Debug.Print line
End Sub

line with a line wrap:
line = "Hello" & Chr(10) & "World"
or
line = "Hello" & vbCrLf & "World"

words with a tab:
line = "Hello" & vbTab & "World"

Sub Test()
Dim line As String
Debug.Print "Hello World"
line = "Hello World"
Debug.Print line
line = "Hello" & Chr(10) & "World"
Debug.Print line
line = "Hello" & vbCrLf & "World"
Debug.Print line
line = "Hello" & vbTab & "World"
Debug.Print line
End Sub

Output:
Hello World
Hello World
Hello
World
Hello
World
Hello World


Regards
Claus B.
--
Windows10
Office 2016

Hi Claus

Thank you for showing me the more correct way to use the formatting functions. Its great that people on this forum take the trouble to help others.

Desmond