What does the Call keyword do in VB6?

by

From the MSDN:

You are not required to use the Call
keyword when calling a procedure.
However, if you use the Call keyword
to call a procedure that requires
arguments, argumentlist must be
enclosed in parentheses. If you omit
the Call keyword, you also must omit
the parentheses around argumentlist.
If you use either Call syntax to call
any intrinsic or user-defined
function, the function’s return value
is discarded.

For example:

Sub Proc1()
    Debug.Print "Hello World"
End Sub

Sub Proc2(text As String)
    Debug.Print "Hello " & text
End Sub

In the immediate window, if you enter

Proc1

then “Hello World” prints. If you enter 

Call Proc1

then “Hello World” prints. If you enter

Proc2 "World"

then “Hello World” prints. If you enter

Call Proc2 "World"

you get a compile error. You would have to enter

Call Proc2("World")

More Related Contents:

  1. Does VBA have Dictionary Structure?
  2. Is there a need to set Objects to Nothing
  3. VB6 pass by value and pass by reference
  4. What is the difference between Dim, Global, Public, and Private as Modular Field Access Modifiers?
  5. Difference between Visual Basic 6.0 and VBA
  6. VBA : save a file with UTF-8 without BOM
  7. IsDate function returns unexpected results
  8. Alternative IDE for VB6 and VBA [closed]
  9. User Defined Type (UDT) as parameter in public Sub in class module (VB6)
  10. delete Autofilter Field resullt using the header Name
  11. Somehow it’s not copying [closed]
  12. Get list of sub-directories in VBA
  13. So, I have 6 “master” files to then divide into 40 separate files
  14. Application.Match gives type mismatch
  15. Getting Error 3340 Query ‘ ‘ is corrupt while executing queries DoCmd.RunSQL
  16. Select first empty cell in column F starting from row 1. (without using offset )
  17. Select Case True
  18. Excel VBA – QueryTable AfterRefresh function not being called after Refresh completes
  19. Excel VBA: AutoFill Multiple Cells with Formulas
  20. Text file in VBA: Open/Find Replace/SaveAs/Close File
  21. VBA.Find and adding a value
  22. excel vba- extract text between 2 characters
  23. Round function in Excel, worksheet function vs VBA
  24. How to continue the code on the next line in VBA
  25. What is behind this difference in parentheses effect in VBA?
  26. Getting Excel to refresh data on sheet from within VBA
  27. Finding first blank row, then writing to it
  28. Does the bitness of the OS ever matter, or is it just the application I need to worry about?
  29. How to have vba execute every 10 minutes?
  30. Read and write from/to registry in VBA

Leave a Comment