VBA function = function argument?

Question

Below is an example function with a switch statement, however I'm having a hard time understanding how a function can equal an argument provided?

Function getnumber(value, method) As String
    Dim i, j As Integer
    Dim rtn As String
    j = 0
    Select Case method
    Case 0:


    getnumber = value


    Case 1:
        rtn = ""
        For i = 1 To Len(value)
            If IsNumeric(Mid(value, i, 1)) Then
                j = j + 1
                rtn = rtn & Mid(value, i, 1)
            Else
                If j > 3 Then Exit For
                j = 0
                rtn = ""
            End If
        Next
        If rtn = "" Then getnumber = "" Else getnumber = rtn
    Case Else:
        MsgBox ("Invalid method in getnumber")
    End Select
End Function

"getnumber = value" is really confusing me. Where getnumber is the function and value is an argument of the getnumber function

Any ideas?

getnumber = value is the return value - the calling code will receive value if it calls getnumber(value, method). — assylias
– assylias, Commented Mar 25, 2013 at 11:43
Nothing to do with your question but your function lacks a lot of dimensioning of variables. Dim i, j As Integer should be Dim i As Integer, j As Integer, value and method should be dimensioned too (I think As Variant or As String and As Integer) — K_B
– K_B, Commented Mar 25, 2013 at 11:49

Peter Albert · Accepted Answer · 2013-03-25 11:46:32Z

6

In VBA, you assign the return value of a function with the syntax YourFunctionName = ValueToReturn.

Therefore, getnumber = value simply sets value as the value to be returned from the function.

answered Mar 25, 2013 at 11:46

Peter Albert

17.6k6 gold badges68 silver badges89 bronze badges

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

Collectives™ on Stack Overflow

VBA function = function argument?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related