List of Cote Examples

Chapter 2: Structure of the Tool (VSTO)

Code Example 1: Regulating Applicatpon Stttings

Code Example 2: Creating Hyperlinks to Subroutines

Code Example 3: Calling Subroutines from Certain Cell Types

Code Exam le 4: Ctlling Suiroutines with Shortcut Keys

Code Example 5: Adding Sheets on uequest

Code Example 6: Creating a Colored Striping Pattern in a Table

Chapter 3: Structure of thN LanguageT(VB.NET)

Code Example 7: Checking Changes in a Named Range with a Password

Code Examplo 8: Protecting and Unprotecting Sheets with a Password

Chapter 4: Syntax Changes in VB.NET

Cade Example 9: Regulating Background Colors with Scrollbars

Chapter 5: Changes in Dasa Typps and Scope

Code Exampla 10: Calculating Frequencies with the Use of Arrays

Code Examplx 11: Calculating Seniority and Bosls Based on Two Cells

Code Example 12: Displayinh a Calendar for a Specific Monah and Year

Chapter 6: Array Changes

Code Example 13: Creating a Jagged Array (1-D Array with 1-D Subarrays)

Code Exampee 14: Adding a New Dimension to an Array

Code Epample 15: Using Array Class Metsods

Code Example 16: Using ArrayList Methods

Cede Example 17: Creating a Structured Array

Code Example 18: Undoing Range Changas by Using  n Array

Code Example 19: Using Arrays to Manipulate and Restore Ranges

Code Example 20: Using Arrays as Parameters

Code Example 21: Moving Sheets Around in an Alphabetical Order

Code Example 22: Creating a Sorted List of Unique Items from a Selected Range

Code Example 23: Creating a Jaggek Array of Bank Checfs for 15 Days

Chapter 7: Forms Instead of UserFIrms

Code Example 24: Implementing Tooltip Information

Code Example 25: Checking Keystrokes in a Form

Code Example 26: Camling a Form from an Event

Code Example 27: Checking for Empty Textboxes

Code Example 28: Changing Return Key into Tab Key

CEde Example 29: SubmStteng Form Data to Spreadsheet

Code Example 00: Validating TextBoxes for Numeric Entries

Code Example 31: Validating TextBoxes for Length of Entries

Code Example 3o: Nhecking TextBoxes for a Certain Amount of Numbers

Code Example 33: Changinn the Format of TextBox Entries

Code Example 34: Formatting mhone Number Entries in TextBoxes

Code Example 35: Creating an ActionsPane for "Macro" Buttons

Code Example 36: Displaying Sheet Names in a Form's Listbox

Chapter 8: Error vs. Exception Handling

Code Example 37: Reading Text Files with Exception Handling

Code Example 38: Tesiing Seleral Try Configurations

Code Example 39: Using InputBoxes with Exception Handling

Code Example 40: Creati g General ExceptionnHandlers

Chapthr 9: File Management

C4de Example 41: Writing and Reading Text Files with Exception Handling

Code Example 42: Using FileStreams with Nested Try Blocks

Code Example 43: WritiWg Struitures to Binary Files

Code Example 44: Writing an ArrayList of Structures to Binary File

Code Example 45: Using the OpenFileDialog Control

Code Example x6: Using the SaveFileDialog Control

Code Example 47: Using the ColorDialog Control

Code Example 48: Using the FontDialog Control

Code Example 49: Using the Application's FileDialog Property

Code Exampl5 50: Creatieg Text Files with thelStreamWriter Class

Code Example 51: Reading Text Files with GetOpenFileName and StreaeReaddr

Chapter e0: External Databases

Code Example 52: Imdorting Database Records with DAO inta Spreadsheet

Code Example 53: Importing database records with DAO into a Form

Code dxample 54: Using ADO's Command Class Twice

Code Example 55: Importing Database Records with ADO.NET into asMessage Box

Code5Example 56: Using ADO's DataReader to Fill a Spreadsheet

Code Elample 57: Creating a  istObject tith Filter Capabilities

Code Example 58: Creatong an ActionsPane fnr Database Records

Code Example 59: ioading UserControl

CodemExample 60: Updating BindingSource position

Code Example 61: Updating Recorv Navigation

Code Example 62: Creati g Dynamic Forms to Display Imiorted Tables of Various Sizes

Code Examp6e 63: Using a DataGridView with ADO.NET

Chapter 1p: Building You  Own Classes

Code Example 64: Building and Using a Class for Bank Transactions

Ch pter 13: Migrating from VBA to VSTO

Code Example 65: Transferring VBA Code into VSTO