Visual Basic

Sorted by:  

Common Visual Studio 2010 Item Templates

When working with projects in Visual Studio 2010, you’ll encounter a dizzying array of item templates to help you create your projects. The following table describes many of the common templates to help [more…]

Common Visual Studio 2010 Project Types

Visual Studio 2010 comes with many project templates to create the necessary boilerplate code and files you need to start developing applications. In the following table, you’ll find some definitions of [more…]

Visual Designers in Visual Studio 2010

Visual Studio 2010 comes with many visual designers to make creating reports, designing classes, designing user interfaces, and modeling data extremely simple and intuitive. The following table lists each [more…]

Visual Studio 2010 Keyboard Shortcuts for General Development Environment

Visual Studio 2010 keyboard shortcuts for the general development environment increase developer productivity by allowing you to perform most common tasks without taking your hands off the keyboard. [more…]

Visual Studio 2010 All-in-One For Dummies Cheat Sheet

Visual Studio 2010 is a complete rewrite of the user interface, but it still has the familiar commands and tools from previous releases. Visual Studio 2010 provides a dizzying array of editors, controls [more…]

General VBA Editor Shortcut Keys

The following table shows you some helpful shortcut keys, and their functions, available throughout the Visual Basic editor, where you write, edit, and test your VBA code. [more…]

VBA Debugging Shortcut Keys

Since code in a programming language has to be written exactly, there can be no errors or bugs. Fortunately, you can debug code in VBA quickly with these debugging shortcuts: [more…]

Common Code for VBA Programming and Debugging in Access

This list which shows you the most common jobs performed in VBA and the statements you need to type to get the VBA task completed, so keep this list handy: [more…]

Navigating and Selecting Code in VBA

Use these VBA shortcuts in the Code window (used for writing, editing, and viewing VBA) and the Immediate window (which lets you run code any time, right on the spot) to get your jobs done quickly. [more…]

Word Namespace Classes for Extending the Office Object Model with VSTO

The Microsoft.Office.Tools.Wordnamespace contains classes that represent objects in the Word object model. Here is a list of the class names, along with their descriptions, that you can use in VSTO to [more…]

Windows Forms Controls in VSTO

VSTO contains two namespaces that hold classes that contain Windows Forms controls, which you can use on the Word documents or Excel worksheets. All controls in the [more…]

Excel Namespace Classes for Extending the Office Object Model in VSTO

In VSTO, the Microsoft.Office.Tools.Excel namespace contains classes that are relevant to the Microsoft Office Excel application. Here are the class names, along with short descriptions: [more…]

VSTO For Dummies Cheat Sheet

Visual Studio Tools for Office (VSTO) extends some of the existing objects in the Office object model. You can use the classes in VSTO namespaces for the Word and Excel application to add or extend the [more…]

Common Shortcuts in VBA-Access 2007

Knowing the most popular keyboard shortcuts in VBA-Access 2007 will help you work more efficiently. Use this shortcut chart until you learn the keyboard combinations and their functions: [more…]

Shortcut Keys to Debug Code in VBA 2007

Avoiding bugs or errors means you have to be precise when writing code in a programming language. Luckily, using these shortcuts will debug code quickly in VBA: [more…]

Common Shortcut Keys in VBA 2007 Editor

Writing, editing, and testing your VBA code in Visual Basic editor will run more smoothly if you learn these helpful shortcut keys and their functions: [more…]

VBA 2007 Shortcuts for Immediate and Code Windows

To get your tasks done quickly in the Immediate window (which lets you run code anytime, right on the spot) and Code window (used for writing, editing, and viewing VBA) use these VBA shortcuts: [more…]

Codes for Common VBA 2007 Tasks

This list shows you the most common jobs carried out in VBA 2007 and the code statements you need to type to complete the VBA task, so keep this list handy: [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…]

Language Changes in Visual Basic .NET

Visual Basic .NET (part of the Visual Studio .NET suite) incorporates a number of language changes for database programmers — whether you are experienced or a beginner. Here's a quick look at some of the [more…]

New Features in Visual Basic .NET

Visual Basic .NET, part of the Visual Studio .NET suite, boasts a number of new features designed to make programming faster and easier. In addition to the basic features, such as variables, data types [more…]


Sign Up for RSS Feeds

Computers & Software