Should I use Call keyword in VB/VBA?

by

Ah ha. I have long wondered about this and even reading a two inch thick book on VBA basically says don’t use it unless you want to use the Find feature of the VBE to easily find calls in large projects.

But I just found another use.

We know that it’s possible to concatenate lines of code with the colon character, for example:

Function Test(mode as Boolean) 
    if mode = True then x = x + 1 : Exit Sub
    y = y - 1
End Sub

But if you do this with procedure calls at the beginning of a line, the VBE assumes that you’re referring to a label and removes any indents, aligning the line to the left margin (even though the procedure is called as intended):

Function Test()
Function1 : Function2
End Function

Using the Call statement allows concatenation of procedure calls while maintaining your code indents:

Function Test()
    Call Function1 : Call Function2
End Function

If you don’t use the Call statement in the above example, the VBE will assume that “Function1” is an label and left align it in the code window, even though it won’t cause an error.

More Related Contents:

  1. Select Case True
  2. Using colons to put two statements on the same line in Visual Basic [closed]
  3. AndAlso/OrElse in VBA
  4. VB6 keyword Set what does it mean?
  5. How to create Control Arrays in VB .NET
  6. How to use comparison methods between class object modules in VBA in a similar manner as VB.NET?
  7. Is VB really case insensitive?
  8. VB6 to VB.net conversion [closed]
  9. Hangman VB Not Working
  10. VB: Unhandled exception [duplicate]
  11. First time execution was not stopped
  12. OleDbException was unhandled…….Syntax error in UPDATE statement
  13. How To Get Control Property by “String Name”?
  14. What is the difference between Dim, Global, Public, and Private as Modular Field Access Modifiers?
  15. (OrElse and Or) and (AndAlso and And) – When to use?
  16. handling dbnull data in vb.net
  17. Syntax error in INSERT INTO statement for Access 2010
  18. IsNothing versus Is Nothing
  19. Is there a VB.NET equivalent of C# out parameters?
  20. Get a list of all files inside of a directory in vb.net
  21. ByVal and ByRef with reference type
  22. How to add a project as a reference of another project
  23. How to escape double quotes in as a parameter to an NUnit TestCase?
  24. Execute a SQL Stored Procedure and process the results [closed]
  25. Why am I getting, “Object reference not set to an instance of an object.” but no line of code is implicated?
  26. Transparency of picture box
  27. VB.NET null coalescing operator? [duplicate]
  28. Collection initialization syntax in Visual Basic 2008?
  29. How do I Merge two Arrays in VBA?
  30. Listen to key press when the program is in the background

Leave a Comment