VBA Articles
Articles tagged VBA, including related tutorials, examples, and walkthroughs.
18 articles
Add Macro Button to the Toolbar in Excel 2011
Here is a short tutorial on how to add a macro button to the toolbar in Excel 2011, with a few tips on how to change the button image....
Control + Home in Excel for Mac
I figured out how to get a Control + Home keyboard shortcut to work in Excel 2011 (for Mac). It's an Excel Windows favorite of mine....
How to Update a List or Range without OFFSET
I avoid the use of Volatile Functions , especially OFFSET, which is commonly used to update a list or range. They can slow down the operation of your workbook....
Select Excel's Used Range on a Mac
Selecting the used range in an Excel worksheet is complicated by not having a Home button on the Mac keyboard. Some VBA code can solve this problem....
Check the Analysis ToolPak Add-In in Excel 2003 [VBA Code]
This VBA code checks to see if the Analysis TookPak Add-In is installed in Excel 2003 when the file is opened, and will notify the user if not....
Select a Column of Non-Sequential Data
This macro will select a column of non-sequential data when the active cell is located in the column heading....
Fill Down a Formula with VBA
Here is some VBA code I use to copy a formula down to the end of a data range. It assumes a heading in row 1 and the formula in row 2....
International Short Date Formatting for the TEXT Function
A quick method to automatically give the TEXT function a short date format that matches the computers region settings by using some VBA code in Excel....
Select One Column of Data with VBA
Select one column of data in a table by using some simple VBA code and a Form button....
Speeding up VBA with the PrintCommunication Property in Excel 2010
Excel 2010's PrintCommunication property in VBA suspends communication with the printer while the code for PageSetup runs, making the code faster....
How to Quickly Convert 1904 Dates to the 1900 Date System in Excel
Learn how to convert 1904 date system values to the 1900 date system in Excel. This guide covers methods for accurate date and date systems management in Excel....
Documentation for VBA in Excel
Documentation for VBA in Excel is arduous yet can save you loads of time when you have forgotten the details of a project....
How to Copy Data to Another Worksheet with Advanced Filter
Unlock the power of Excel's Advanced Filter to seamlessly copy and organize data between worksheets. Learn techniques for precise data migration and efficient workflow....
Automatically Expand a Named Range in Excel
Automatically expand the name reference of a data table when a user adds more data by using the sheet deactivate routine to call a simple subroutine....
VBA Help System Lacking in Excel 2011
The VBA Help system for Excel 2011 for Mac is a tangled web of confusion that's frustrating and difficult to say the least. Excel 2010 is much better....
ISNUMBER vs IsNumeric in Excel: Worksheet and VBA Differences
Learn the difference between Excel ISNUMBER and VBA IsNumeric, including how they handle text numbers, blanks, dates, and data-entry cleanup....
Hide or Show Names in Excel with VBA
Names can be hidden or shown in Excel with some simple VBA code....
Hide Worksheets in Excel
Change the visible property of a worksheet to make it very hidden and won't show in the Unhide sheet dialog box....
About Excel Semi Pro
Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.
Read more about us