Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

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…]

Advertisement

Sign Up for RSS Feeds

Computers & Software
Win an iPad Mini! Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!