Return to VBA Code Examples

Advanced VBA Programming Examples

Below you will find a list of advanced VBA programming examples and tutorials.

 

Advanced VBA Code Examples  
Ranges and Cells
VBA Function: Populating a Range
Rows & Columns
Converting a Single Row Vector into a Matrix
Sheets
Sort Sheets Alphabetically with VBA
Use Worksheet Functions in a Macro
Text and Strings
Calculate Acronyms from Strings
VBA Coding Concepts
VBA Best Practices
Hide a Macro
Settings
Change User Name with VBA
Modify the titlebar
Shapes, Charts, and Objects
Programmatically Draw Boxes with Code
Misc.
Speak to Me
Start a Screen Saver with VBA
Get Current Weather in Excel
User Interaction
Transparent Forms
Variables
Static Variables
Determine a Variable's Underlying Type
Internet
WinHttpRequest with Login and Password - Misc Bloglines
Consume Soap Web Services
Image Control Problem - Can't LoadPicture() from URL
Search Google from a cell
Advanced Programming
Convert Matrix to Vector
VBA - Programming the VBE (Visual Basic Editor)
Functions
Environ Function - Excel VBA
Show Cell Formula