Macros & Excel 2013 Programming

View:  
Sorted by:  

How to Record New Macros in Excel 2013

Excel 2013 enables you to add an optional Developer tab to the Ribbon that contains its own Record Macro command button (among other command buttons that are very useful when doing more advanced work with [more…]

How to Run Macros Macro in Excel 2013

After you record a macro in Excel 2013, you can run it by clicking the View Macros option on the Macros button’s drop-down menu on the View tab, the Macros button on the Developer tab of the Ribbon, or [more…]

How to Assign Macros to the Ribbon and the Quick Access Toolbar in Excel 2013

You can assign a macro to a custom tab on the Ribbon or a custom button on the Quick Access toolbar in Excel 2013 and then run it by clicking that custom button. [more…]

Top Ten Excel VBA Control Structures

Following is a list of the ten most commonly used Excel VBA programming control structures. Included is a simple example of each control structure and a brief description of when you would use that structure [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…]

How to Edit Macros in Excel's Visual Basic Editor

After you’ve created a macro in Excel 2013, you don’t necessarily have to re-record it to change the way it behaves. In many cases, you will find it more expedient to change its behavior by simply editing [more…]

How to Find and Replace Code in a Visual Basic Editor Macro

You can use the Find feature in the Visual Basic Editor to quickly locate the statements or properties that need editing in your Excel 2013 macro. You open the Find dialog box by choosing Edit→Find on [more…]

How to Add Dialog Boxes to Excel Macros with Visual Basic Editor

You can use the InputBox function to add dialog boxes to your Excel 2013 macros. When you run the macro, this Visual Basic function causes Excel to display an Input dialog box where you can enter whatever [more…]

Write New Macros in the Visual Basic Editor in Excel 2013

After you have the skill in the VBA language, you can write new macros from scratch in the Visual Basic Editor instead of just editing ones that you’ve previously recorded in your spreadsheet by using [more…]

Save Custom Functions from Excel VBA in Add-in Files

To be able to omit the filename from the custom functions that you create in Excel 2013 when you enter them directly into a cell, you need to save the workbook file that contains them as a special add-in [more…]

Macro Security and Authenticode in Excel 2013

Excel 2013 uses a system called Microsoft Authenticode that enables developers to authenticate their macro projects or add-ins created with Visual Basic for Applications by a process referred to as [more…]

Common VBA Statements for Excel VBA Programming

The following table provides a list of commonly used VBA statements that you might use when creating macros for Excel. For more information on a particular statement, consult Excel’s Help system. [more…]

VBA Functions for Excel VBA Programming

The VBA language contains a number of functions that you can use to build code in Excel. The following table provides descriptions of the most useful functions. When writing code, type the word VBA followed [more…]

Excel VBA Programming For Dummies Cheat Sheet

The Visual Basic for Applications (VBA) programming language lets you automate many aspects of Excel by writing Sub and Function procedures (also known as macros). A good knowledge of VBA can save time [more…]

3 Reasons to Use Macros for Your Excel Dashboards

Macros are very useful for your Excel dashboards and reports. 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 [more…]

Excel Dashboards: How to Record Your First Macro

If you’re a beginner to dashboard automation in Excel, it’s unlikely that you’ll be able to write the VBA (Visual Basic for Applications) code by hand to create macros. Without full knowledge of Excel’s [more…]

Excel Dashboards and Reports: How to Run Your Macros

Macros are very useful for your Excel dashboards and reports. To see your macros in action, select the Macros command from the Developer tab. The dialog box shown in this figure appears, allowing you to [more…]

Enable and Trust Macros for Your Excel Dashboards and Reports

With the release of Office 2007, Microsoft introduced significant changes to its Office security model. One of the most significant changes affecting Excel dashboards and reports is the concept of trusted [more…]

How to Find Form Controls for Excel Dashboards and Reports

Excel offers a set of controls called Form controls, designed specifically for adding user interface elements to your dashboards and reports. After you place a Form control on a worksheet, you can then [more…]

How to Add a Control to Excel Dashboards and Reports

Today, business professionals increasingly want to be empowered to switch from one view of data to another, in Excel dashboards and reports, with a simple list of choices. For those who build dashboards [more…]

Use the Button Control for Your Excel Dashboards and Reports

Excel offers a set of controls called Form controls, designed specifically for adding user interface elements to your dashboards and reports. After you place a Form control on a worksheet, you can then [more…]

Use the Check Box Control for Your Excel Dashboards

Excel offers a set of controls called Form controls, designed specifically for adding user interface elements to your dashboards and reports. After you place a Form control on a worksheet, you can then [more…]

Use the Option Button Control for Your Excel Dashboards

Option buttons allow users to toggle through several options on an Excel dashboard or report one at a time. The idea is to have two or more option buttons in a group. Then selecting one option button automatically [more…]

Excel Dashboards and Reports: Option Button Example

One of the ways you can use option buttons in your Excel dashboards and reports is to feed a single chart with different data, based on the option selected. This figure illustrates an example of this. [more…]

Use the Combo Box Control for Your Excel Dashboards

The Combo Box control allows users to select from a drop-down list of predefined options on an Excel dashboard or report. When an item from the Combo Box control is selected, some action is taken with [more…]

Listings:1-2526-27

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.