Return a String from a Function

[rmweaver81]

Sub TrackChanges()
    Dim editWord As String


    editWord = GetWord()


End Sub


Function GetWord() As String


    Dim wordStr As String


    wordStr = "What am I doing wrong?"


End Function

In VB.Net, functions are used to process something and return some value. You actually have to type the word "Return". Apparently, this is not the case with VBA. When I run the following code, the value of editWord is "", when I would expect it to be "What am I doing wrong?", which begs the question, what am I doing wrong? Any help would be greatly appreciated!

 

[Jonmo1]

Welcome to the baord...

Try

Sub TrackChanges()
    Dim editWord As String

    editWord = GetWord()

End Sub

Function GetWord() As String
 
    GetWord = "What am I doing wrong?"

End Function

 

[VoG]

Surely it should be

GetWord="What am I doing wrong"

 

[rmweaver81]

That simple?! It worked perfectly! Thanks for the help!

 

[Jonmo1]

Glad to help, thanks for the feedback.