VBa Function, Possible Line Feed?

[Stephen_IV]

Is it possible to line feed in a function? Like after results vbCrLf

Something like
"Washington" & vbCrLf & "Lincoln" & vbCrLf & "Columbus" & "Johnson" & vbCrLf & "Roosevelt"

Function PopDen(s As String) As String
    Select Case Trim(s)
        Case "06554", 6554: PopDen = "Washington, Lincoln, Columbus, Johnson, Roosevelt"
    End Select
End Function

 

[shg]

Function PopDen(s As String) As String
  Select Case Trim(s)
    Case "06554", 6554
      PopDen = Join(Array("Washington", "Lincoln", "Columbus", "Johnson", "Roosevelt"), vbLf)
  End Select
End Function

 

[Fluff]

Have you tried it?

 

[shg]

Or

Function PopDen(s As String) As String
  Select Case Trim(s)
    Case "06554", 6554
      PopDen = Join(Split("Washington Lincoln Columbus Johnson Roosevelt"), vbLf)
  End Select
End Function

 

[Fluff]

or even

Function PopDen(s As String) As String
    Select Case Trim(s)
        Case "06554", 6554: PopDen = Replace("Washington, Lincoln, Columbus, Johnson, Roosevelt", ", ", vbLf)
    End Select
End Function

 

[Stephen_IV]

Sorry was in a meeting!

Thanks shg and Fluff. That's what I was looking for!! Appreciate it!!! Thank you again for your time!!

 

[Fluff]

You're welcome & thanks for the feedback