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()"

either Function hi() As String , or you need to declare hi somewhere. Why do you need a Function ? why not a regular Sub ? — Shai Rado
– Shai Rado, Commented Dec 14, 2016 at 11:26
thanks Shai Rado. i am not yet selecting function or sub for a particular reason. first i need to find out how thy work :( see the edited original post, a added 2 images of my error — user1805743
– user1805743, Commented Dec 14, 2016 at 11:34
Calling a function with parenthesis will return an object, so it's expecting s=hi() or call hi to just run — Nathan_Sav
– Nathan_Sav, Commented Dec 14, 2016 at 11:37
thanks, i guess that's it. sorry for wasting your time on such stuff. — user1805743
– user1805743, Commented Dec 14, 2016 at 11:40
If you want to call your function from the Immediate pane and print the output then you need to call it like this : ? hi() (same as Debug.Print hi()) — Tim Williams
– Tim Williams, Commented Dec 14, 2016 at 17:32

skygate · Accepted Answer · 2021-12-17 11:13:00Z

9

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

edited Dec 17, 2021 at 11:13

skygate

3772 silver badges13 bronze badges

answered Dec 14, 2016 at 11:40

Shai Rado

33.7k7 gold badges32 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jeremy Caney · Accepted Answer · 2024-04-10 00:29:58Z

0

You need to do this

Public Function ExampleName() As String
  'code
End Function

You can put any of the available variables such as long, string, integer, etc...

edited Apr 10, 2024 at 0:29

Jeremy Caney

7,808115 gold badges58 silver badges86 bronze badges

answered Apr 6, 2024 at 17:48

Jaime Jaimico

11 bronze badge

Collectives™ on Stack Overflow

Return a string from a VBA function

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related