A function returns a value to whomever called it. : Function « Language Basics « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Language Basics
  3. Function

A function returns a value to whomever called it.

 

Sub useaFunction()
   MsgBox concatF()
End Sub
Function concatF() As String
    Dim strFirstname As String
    Dim strLastName As String
    Dim strFullName As String

    strFirstname = "John"
    strLastName = "Smith"

    strFullName = strFirstname & " " & strLastName
    concatF = strFullName
End Function








Related examples in the same category

1.Writing VBA Function Procedures
2.A function returns a value to whomever called it. We can recast the previous sub into a function as follows:
3.Call user-defined function in MsgBox
4.Executing a Function Procedure from a Subroutine
5.One of simplest possible custom functions
6.function takes two arguments's length and width's and calculates the total area by multiplying them together
7.Convert Fahrenheit To Celsius
8.Use ElseIf in a function
9.Select Case in a function
10.A function with one argument