Macros & Excel 2013 Programming

Sorted by:  

Use the List Box Control for Your Excel Dashboards

You can use List Box controls to allow your Excel dashboard and report users to select from a list of predefined choices. When an item from the List Box control is selected, some action is taken with that [more…]

Where Is the Visual Basic Editor in Excel 2013?

Where the heck did they stick this Visual Basic Editor that you’ve heard so much about? Actually, the Visual Basic Editor in Excel 2013 is always ready to step forward whenever you press Alt+F11 or click [more…]

Excel Macros: Standard Visual Basic Editor Shortcut Keys

Microsoft Excel shortcut keys allow you to perform certain tasks using only the keyboard. Getting in the habit of using these shortcut keys can help you work more efficiently because you limit the number [more…]

Excel Macros: Shortcut Keys for Working in the Code Window in Visual Basic Editor

At some point, you may find yourself working with many Excel macros at one time. It can be tedious trying to navigate between and within macro procedures by clicking around with the mouse. These keyboard [more…]

Shortcut Keys for Debugging Code in Excel’s Visual Basic Editor

Debugging your code is an important part of working with Excel macros. Although there are ways to use the debugging features through the Visual Basic Editor menu options, you may find the following keyboard [more…]

Excel Macros: Shortcut Keys for Navigating the Project Window in Visual Basic Editor

Want to navigate your Visual Basic projects without reaching for the mouse? Well, Excel gives you just what you need to do that with ease. Try using the following keyboard shortcuts to move between projects [more…]

An Overview of the Excel Object Model

Visual Basic for Applications is an object-oriented programming language. The basic concept of object-oriented programmingis that a software application [more…]

10 Ways to Speed Up Your Macros

As your Excel macros become increasingly robust and complex, you may find that they lose performance. When discussing macros, the word performance is usually synonymous with [more…]

10 Places to Turn for Excel Macro Help

No one can become an Excel macro expert in one day. VBA is a journey of time and practice. The good news is that there are plenty of resources out there that can help you on your path. Here are ten of [more…]

10 Handy Visual Basic Editor Tips

If you're going to be spending time working with macros in Visual Basic Editor, why not take advantage of a few of the built-in tools that will make your job easier? These tips will greatly improve your [more…]

Why Use an Excel Macro?

A macro is essentially a set of instructions or code that you create to tell Excel to execute any number of actions. In Excel, macros can be written or recorded. The key word here is [more…]

Macro Recording Basics

To start recording your first macro in Excel, you need to find Macro Recorder, which is on the Developer tab. Unfortunately, Excel comes out of the box with the Developer tab hidden — you may not see it [more…]

Recording Excel Macros with Absolute References

Excel's default recording mode is absolute reference. When a cell reference in a formula is an absolute reference, it does not automatically adjust when the formula is pasted to a new location. [more…]

Recording Excel Macros with Relative References

A relative reference in an Excel macro means relative to the currently active cell. So use caution with your active cell choice — both when you record the relative reference macro and when you run it. [more…]

Macro Security in Excel 2010

With the release of Office 2010, Microsoft introduced significant changes to its Office security model. One of the most significant changes is the concept of trusted documents. Without getting into the [more…]

Trusted Locations and Excel Macros

If the thought of any Excel macro message coming up (even one time) unnerves you, set up a trusted location for your files. A trusted location is a directory that is deemed a safe zone where only trusted [more…]

Store Excel Macros in Your Personal Macro Workbook

Most user-created macros are designed for use in a specific workbook, but you may want to use some macros in all your work. You can store these general-purpose macros in the personal macro workbook so [more…]

Build Navigation Buttons with Excel Macros

The most common use of macros is in navigation. Workbooks that have many worksheets or tabs can be frustrating to navigate. To help your audience, you can create a switchboard, like the one shown here. [more…]

Visual Basic Editor Components

Visual Basic Editor is a separate application that runs when you open Excel. To see this hidden VBE environment, you'll need to activate it. The quickest way to activate VBE is to press Alt+F11 when Excel [more…]

The Project Window in Visual Basic Editor and Excel Macros

When you're working in VBE, each open Excel workbook is a project. You can think of a project as a collection of objects arranged as an outline.

You can expand a project by clicking the plus sign [more…]

How to Minimize and Maximize Code Windows

As you become proficient with VBA, you'll spend lots of time working in code windows. Excel macros that you record are stored in a module, and you can type VBA code directly into a VBA module. [more…]

How to Get VBA Code into a Module with Code Windows

One of the way in which you can get VBA code into a VBA module is to use the Excel macro recorder to record your actions and convert them to VBA code. However, not all tasks can be translated to VBA by [more…]

How to Customize the VBA Environment through the Editor Tab

If you're serious about becoming an Excel programmer, you'll spend a lot of time with VBA modules on your screen. To help make things as comfortable as possible, VBE provides quite a few customization [more…]

How to Customize the VBA Environment through the Editor Format Tab

The options on the Editor Format tab of the Visual Basic Editor (VBE) Options dialog, box shown, here enable you to customize the way VBE looks. [more…]

An Excel Macro to Hide All but the Active Worksheet

You may want to hide the inactive worksheets with this macro. Excel doesn't let you hide all sheets in a workbook; at least one has to be displayed. However, you can hide all but the active sheet. [more…]


Sign Up for RSS Feeds

Computers & Software
Win $500. Enter Now.