How-To Geek on MSN

5 more Excel VBA toolbar shortcuts that work in every spreadsheet I open

These reusable shortcuts handle pasting, navigation, cleanup, indexing, and timestamps from any standard Excel workbook.
TechRepublic

How to use VBA’s InputBox function to select a range on the fly in Excel

Automating the selection process isn’t difficult if you rely on VBA’s InputBox in Microsoft Excel. Often, you’ll want Excel users to specify a range that the app then uses in an automated way.
CCM

VBA select case like: operator, string, statement

Both Select Case and Like operators are powerful and extremely useful commands in VBA language , but under normal circumstances, they don't work together. In this article you will learn how to ...
How-To Geek on MSN

I built my own Excel toolbar using basic VBA, and it works in every spreadsheet I open

VBA may have a bad reputation, but it's still one of the most effective ways to automate repetitive actions in standard XLSX workbooks.