Calling Functions in VB & VBA: Syntax, Examples, & More

PDF download Download Article
PDF download Download Article

Are you confused about calling function procedures in Visual Basic and VBA? This wikiHow tutorial will teach you easy ways to call functions in VB and VBA.

Section 1 of 2:

Calling a Function Syntax

PDF download Download Article
  1. The syntax for calling a function in VB and VBA is lvalue = functionName (argument1, argument2) . If there is more than one argument (like in this example), you'll separate the arguments with commas. [1]
    • You must provide values for all arguments that aren't optional. But if there are no arguments, you can omit the parentheses or just leave them blank () . [2]
    • When you call a function, its statements run beginning with the first executable statement after the Function statement until End Function , Return , or Exit Function is encountered. [3]
    • Unlike when calling a subroutine, you usually won't need to include the Call keyword when calling a function. [4] If you use the Call keyword, no value will be returned.
    • If you're using VBA in a cell within an Excel spreadsheet, the syntax is =functionName(argument1, argument2) . If you're writing code in the Excel VB editor, you'll use the standard syntax. But in a cell, you'll need to preface the call with an equals sign as you would when writing a formula.
    2. Advertisement
Section 2 of 2:

Function Calling Examples

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ae\/621304-1.jpg\/v4-460px-621304-1.jpg","bigUrl":"\/images\/thumb\/a\/ae\/621304-1.jpg\/v4-728px-621304-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}
    [5] Then, we'll call that function to find the hypotenuse for a triangle if one of the lines is 2.3 .
    • First, let's create the function. 
       Function 
 hypotenuse 
 ( 
 ByVal 
 side1 
 As 
 Single 
 , 
 ByVal 
 side2 
 As 
 Single 
 ) 
 As 
 Single 
 Return 
 Math 
 . 
 Sqrt 
 (( 
 side1 
 ^ 
 2 
 ) 
 + 
 ( 
 side2 
 ^ 
 2 
 )) 
 End 
 Function
    • And here's how we'd call the function if one side is 2.3 . 
       Dim 
 testLength 
 , 
 testHypotenuse 
 As 
 Single 
 testHypotenuse 
 = 
 hypotenuse 
 ( 
 testLength 
 , 
 2.3 
 )
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/58\/621304-2.jpg\/v4-460px-621304-2.jpg","bigUrl":"\/images\/thumb\/5\/58\/621304-2.jpg\/v4-728px-621304-2.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}
    In this example, we'll call the MsgBox function, which displays a message box to the user and accepts input. There are 5 possible named arguments for MsgBox in Visual Basic and VBA— prompt , buttons , title , helpfile , and context . [6] We want to pass two arguments—one to display a message, and another to display yes and no buttons: 
     Dim 
 intResponse 
 As 
 Integer 
 intResponse 
 = 
 MsgBox 
 ( 
 "Are you sure you want to proceed?" 
 , 
 vbYesNo 
 ) 
 If 
 intResponse 
 = 
 vbYes 
 Then 
 End 
 End 
 If
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/49\/621304-3.jpg\/v4-460px-621304-3.jpg","bigUrl":"\/images\/thumb\/4\/49\/621304-3.jpg\/v4-728px-621304-3.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}
    First we'll write a function called Add , and then we'll call the function to add the numbers 32 and 64 .
    • First, here's the function: [7] 
       Function 
 Add 
 ( 
 ByVal 
 x 
 As 
 Integer 
 , 
 ByVal 
 y 
 As 
 Integer 
 ) 
 As 
 Integer 
 Dim 
 Res 
 as 
 integer 
 Res 
 = 
 x 
 + 
 y 
 Add 
 = 
 Res 
 End 
 Function
    • Now, let's call the function in a subroutine to add our numbers: 
       Sub 
 Form_Load 
 () 
 Dim 
 a 
 As 
 Integer 
 Dim 
 b 
 As 
 Integer 
 Dim 
 c 
 As 
 Integer 
 a 
 = 
 32 
 b 
 = 
 64 
 c 
 = 
 Add 
 ( 
 a 
 , 
 b 
 ) 
 MsgBox 
 ( 
 "Sum is : " 
 & 
 c 
 ) 
 End 
 Sub
    4. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How do I run a function in VB.net?
    Snod
    Community Answer
    Click Compile then Run using the menu. There may also be keyboard shortcut hotkeys.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 4 Helpful 1
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      • Functions are public by default, so you can call them from anywhere in the program that has access to its containing class, module, or structure.
        Thanks
        Helpful 0 Not Helpful 0
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      You Might Also Like

      How to
      Add Two Numbers in Visual Basic.NET
      2 Simple Ways to Format Text Into Code on Discord
      How to
      Change 4-Digit User Codes on Schlage Locks
      How to
      Run a Program from the Command Line on Linux
      How to
      Delay a Batch File: Timeout, Pause, Ping, Choice & Sleep
      Converting Binary to Decimal: Positional Notation & Doubling
      How to
      Factory Reset a Schlage Lock & Restore the Default Programming Code
      Learn to Write Pseudocode: What It Is and Why You Need It
      3 Ways to Download GitHub Directories and Repositories
      How to
      Make an Exe File
      Convert from Decimal to Hexadecimal: A Quick Guide + Examples
      How to
      View Source Code
      How to
      Make a Program Using Notepad
      How to
      Update R in RStudio or Manually: Step-by-Step Guide
      Advertisement

      References

      1. ↑ https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/call-statement
      2. ↑ https://learn.microsoft.com/en-us/dotnet/visual-basic/programming-guide/language-features/procedures/function-procedures
      3. ↑ https://learn.microsoft.com/en-us/dotnet/visual-basic/programming-guide/language-features/procedures/function-procedures
      4. ↑ https://learn.microsoft.com/en-us/dotnet/visual-basic/language-reference/statements/function-statement
      5. ↑ https://learn.microsoft.com/en-us/dotnet/visual-basic/programming-guide/language-features/procedures/function-procedures
      6. ↑ https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/msgbox-function
      7. ↑ https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/add-method-visual-basic-for-applications

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 163,487 times.

      Is this article up to date?

      Advertisement