Visual Basic conceptual topics In this section 64-Bit Visual Basic for Applications Overview Avoiding Naming Conflicts Calling Procedures with the Same Name Calling Property Procedures Calling Sub and Function Procedures Creating Object Variables Creating Recursive Procedures Declaring Arrays Declaring Constants Declaring Variables Executing code when setting properties Looping Through Code Making Faster For...Next Loops Passing Arguments Efficiently Returning Strings from Functions Understanding Automation Understanding Conditional Compilation Understanding Named Arguments and Optional Arguments Understanding Objects, Properties, Methods, and Events Understanding Parameter Arrays Understanding Scope and Visibility Understanding the Lifetime of Variables Understanding Variants Understanding Visual Basic Syntax Using Arrays Using Constants Using Data Types Efficiently Using Do...Loop Statements Using For Each...Next Statements Using For...Next Statements Using If...Then...Else Statements Using Parentheses in Code Using Select Case Statements Using the Add-In Manager Using With Statements Visual Basic Naming Rules Working Across Applications Writing a Function Procedure Writing a Property Procedure Writing a Sub Procedure Writing Assignment Statements Writing Data to Files Writing Declaration Statements Writing Executable Statements Writing Visual Basic Statements