Passing by Reference Versus Passing by Value : Function Parameter « Language Basics « VBA / Excel / Access / Word

Passing by Reference Versus Passing by Value

Sub PassByRef()
    Dim strFirstName As String
    Dim strLastName As String
    strFirstName = "A"
    strLastName = "Balter"

    Call FuncByRef(strFirstName, strLastName)

    Debug.Print strFirstName
    Debug.Print strLastName
End Sub
Sub FuncByRef(strFirstParm As String, strSecondParm As String)
    strFirstParm = "A"
    strSecondParm = "B"
End Sub


Related examples in the same category

2.Writing a Function Procedure with Arguments
3.Pass string value through Parameters
4.Optional Parameters
5.Default value parameters
6.Substitute a default value if an optional parameter is not provided
7.Named parameters
8.Using the Select Case Statement to check the function parameter
9.Passing Arrays as Parameters
10.Pass by value
11.Illustrate a reason why you might want to pass a parameter by reference
12.Optional Parameters: Building Flexibility into Functions
13.Inserting Default Values When Parameters Are Missing
14.Accommodating for Missing Parameters in Your Code
15.Named Parameters: Eliminate the Need to Count Commas
16.Pass array parameter to a function
17.Double type parameter
18.Object parameter