Return a string from a VBA function

Question

I am following a tutorial and get a compile error at the hello world example function.

What's wrong here?

Here is the code I tried:

Function hi()
    hi = "hello world"
End Function`

edit: suggested declarations didn't help

edit: getting closer. brackets seem to be a problem when calling "hi()"

Answer 1

You can use 2 ways to implement your "Hello World" example.

Option 1: Simple and good enough for your example, using a regular Sub :

Sub Hi_()

Dim HiStr   As String

HiStr = "Hello World"
MsgBox HiStr

End Sub

---

Option 2: Using a Function with "Hello World" example:

Function Hi(TestHi As String) As String

' Input: this function receives a string as a parameter
' Output: returns a string

Hi = "Test Function with " & TestHi

End Function

Now we need a Sub to test the Function:

Sub Test_Hi_Function()

Dim TstHiFunc As String

' send "Hello World" to Function Hi as a parameter
' TstHiFunc gets the returned string result 
TstHiFunc = Hi("Hello World")

' for debug only
MsgBox TstHiFunc

End Sub