Visual Basic conceptual topics

Information to help you get started with Visual Basic programming.

Note

Interested in developing solutions that extend the Office experience across multiple platforms? Check out the new Office Add-ins model. Office Add-ins have a small footprint compared to VSTO Add-ins and solutions, and you can build them by using almost any web programming technology, such as HTML5, JavaScript, CSS3, and XML.

• 64-bit Visual Basic for Applications overview
• Avoid naming conflicts
• Call procedures with the same name
• Call Property procedures
• Call Sub and Function procedures
• Create object variables
• Create Recursive procedures
• Declare arrays
• Declare constants
• Declare variables
• Execute code when setting properties
• Loop through code
• Make faster For...Next loops
• Pass arguments efficiently
• Return 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
• Use arrays
• Use constants
• Use data types efficiently
• Use Do...Loop statements
• Use For Each...Next statements
• Use For...Next statements
• Use If...Then...Else statements
• Use parentheses in code
• Use Select Case statements
• Use the Add-In Manager
• Use With statements
• Visual Basic naming rules
• Work across applications
• Write a Function procedure
• Write a Property procedure
• Write a Sub procedure
• Write assignment statements
• Write data to files
• Write declaration statements
• Write executable statements
• Write Visual Basic statements

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.