Visual Basic for Applications

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780619000202 | 0619000201
Cover: Paperback
Copyright: 6/22/2000

Buy New

This is a hard-to-find title. We are making every effort to obtain this item, but do not guarantee stock.

$236.36

This title teaches how to program in VBA by showing users how to manipulate objects in each Office application.Visual Basic for Applications offers a concept lesson, followed by lessons in Word, Access, and Excel, with PowerPoint covered in the end of chapter exercises. This title stresses the commonality of VBA in all the Office applications.

Preface

iii

Read This Before You Begin

xxii

Overview A Brief History of Basic, Microsoft, and Visual Basic for Applications

(1)

BASIC and Microsoft Corporation

(2)

The Beginning of Microsoft

(2)

Why Should You Learn VBA?

(1)

Using the Tutorials Effectively

(3)

Using The Visual Basic Editor

(74)

Concept Lesson

(21)

Procedures

(1)

The Visual Basic Editor

(7)

Entering Instructions in the Code Window

(3)

Saving a Procedure

(1)

Running a Procedure

(1)

Printing a Procedure

(1)

Summary

(3)

Review Questions

(1)

Exercises

(4)

Excel Lesson: Using the Visual Basic Editor in Excel

(16)

Using the Visual Basic Editor in Microsoft Excel

(4)

Coding the Workbook Object's Open Event Procedure

(4)

Coding the GetGenius Macro Procedure

(5)

Exercises

(3)

Word Lesson: Using the Visual Basic Editor in Word

(16)

Using the Visual Basic Editor in Microsoft Word

(5)

Coding the Document Object's Open Event Procedure

(4)

Coding the DisplayDate Macro Procedure

(5)

Exercises

(2)

Access Lesson: Using the Visual Basic Editor in Access

(20)

Using the Visual Basic Editor in Microsoft Access

(4)

Coding the Form Object's Close Event Procedure

(6)

Coding the CancelAssistMacro Procedure

(3)

Creating a Function Procedure in Access

(4)

Exercises

(3)

The Object Model

(72)

Concept Lesson

(18)

Understanding the Object Model

(1)

Referring to the Objects Contained in an Application's Object Model

(2)

Referring to Objects in VBA Code

(1)

Referring to an Object's Properties and Methods in VBA Code

(1)

The Object Browser

(2)

Getting Help in the Object Browser

Using the Immediate Window

(11)

Repeating and Deleting Instructions in the Immediate Window

(1)

Printing Code from the Immediate Window

(1)

Summary

(1)

Review Questions

(1)

Exercises

(4)

Excel Lesson: The Excel Object Model

100

(19)

Understanding the Excel Object Model

100

(2)

Using the Object Browser in Excel

102

(6)

Using the Immediate Window in Excel

108

(4)

Referring to Range Objects

112

(3)

Exercises

115

(4)

Word Lesson: The Word Object Model

119

(19)

Understanding the Word Object Model

119

(2)

Using the Object Browser in Word

121

(7)

Using the Immediate Window in Word

128

(6)

Using the Range Object's Select Method

134

(1)

Exercises

134

(4)

Access Lesson: The Access Object Model

138

(15)

Understanding the Access Object Model

138

(2)

Using the Object Browser in Access

140

(6)

Using the Immediate Window in Access

146

(4)

Exercises

150

(3)

Object Variables

153

(54)

Concept Lesson

154

(14)

Memory Cells

154

(2)

Variables

156

(1)

Object Variables

157

(2)

Reserving a Procedure-Level Variable

159

(1)

Selecting the Appropriate Data Type and Name for an Object Variable

160

(3)

Using the Set Statement

163

(1)

Summary

164

(1)

Review Questions

164

(2)

Exercises

166

(2)

Excel Lesson: Creating and Using Object Variables in Excel

168

(16)

Creating the FormatWorksheet Macro Procedure

168

(5)

Inserting Rows into a Worksheet

173

(2)

Entering a Value into a Range Object

175

(1)

Entering a Formula into a Range Object

176

(1)

Formatting a Range Object

177

(2)

Previewing and Printing a Worksheet Object

179

(2)

Exercises

181

(3)

Word Lesson: Creating and Using Object Variables in Word

184

(11)

Creating the FormatPromo Macro Procedure

184

(4)

Applying a Theme to a Document

188

(2)

Changing the Document's Font Size

190

(1)

Adding a Hyperlink to a Document

190

(2)

Exercises

192

(3)

Access Lesson: Creating and Using Object Variables in Access

195

(12)

Creating the DisplayByGrade Procedure

195

(3)

Opening an Access Report

198

(2)

Ordering the Records in a Report

200

(1)

Creating the DisplayByGradeMacro Macro

201

(2)

Exercises

203

(4)

String Variables

207

(60)

Concept Lesson

208

(18)

Variables

208

(1)

Reserving a Procedure-level String Variable

208

(3)

Using an Assignment Statement to Assign a Value to a String Variable

211

(1)

Using the InputBox Function

212

(2)

Concatenating Strings

214

(2)

Using the VAL Function

216

(2)

The Option Explicit Statement

218

(2)

Summary

220

(1)

Review Questions

221

(3)

Exercises

224

(2)

Excel Lesson: Using String Variables in Excel

226

(12)

Coding the Workbook's Open Event Procedure

226

(7)

Exercises

233

(5)

Word Lesson: Using String Variables in Word

238

(19)

Creating a Facsimile Transmittal Sheet

238

(1)

Using Form Fields

239

(4)

Creating the FaxTransmittal Macro Procedure

243

(6)

Creating a Custom Toolbar and Button

249

(4)

Exercises

253

(4)

Access Lesson: Using String Variables in Access

257

(10)

Creating the SelectFieldOrder Procedure

257

(5)

Creating the SelectFieldOrderMacro Macro

262

(2)

Exercises

264

(3)

Date Variables

267

(58)

Concept Lesson

268

(19)

Date Variables

268

(1)

Reserving a Procedure-level Date Variable

268

(1)

Using an Assignment Statement to Assign a Value to a Date Variable

268

(2)

Using VBA's Date, Time, and Now Functions

270

(2)

Using the Format Function

272

(1)

Using Dates and Times in Calculations

273

(4)

Converting Strings to Dates

277

(2)

Summary

279

(1)

Review Questions

280

(1)

Exercises

281

(6)

Excel Lesson: Using Date Variables in Excel

287

(14)

Creating the CalcHours Macro Procedure

287

(5)

The Offset Property

292

(3)

Exercises

295

(6)

Word Lesson: Using Date Variables in Word

301

(11)

Coding the PrintInvitation Procedure

301

(4)

Printing a Document

305

(3)

Exercises

308

(4)

Access Lesson: Using Date Variables in Access

312

(13)

Creating the AssignDates Procedure

312

(4)

Referring to a Control on a Form

316

(1)

Creating a Custom Toolbar and Button

317

(4)

Exercises

321

(4)

Numeric Variables

325

(66)

Concept Lesson

326

(12)

Reserving a Procedure-level Numeric Variable

326

(2)

Using an Assignment Statement to Assign a Value to a Numeric Variable

328

(1)

Assigning a Numeric Literal Constant to a Numeric Variable

328

(2)

Assigning a Numeric Expression to a Numeric Variable

330

(2)

Summary

332

(1)

Review Questions

332

(2)

Exercises

334

(4)

Excel Lesson: Using Numeric Variables in Excel

338

(24)

Viewing the Paradise Electronics Price List

338

(2)

Creating a List Box

340

(7)

Coding the ListBox's DblClick Event Procedure

347

(3)

Using the Excel VLookup Function in a Procedure

350

(5)

Exercises

355

(7)

Word Lesson: Using Numeric Variables in Word

362

(13)

Coding the UpdateMembership Procedure

362

(4)

Searching a Table

366

(2)

Moving the Insertion Point to the Beginning of the Document

368

(2)

Exercises

370

(5)

Access Lesson: Using Numeric Variables in Access

375

(16)

The ADO Object Model

375

(1)

Coding the PaymentUpdate Procedure

376

(4)

Using the Recordset Object's Open Method

380

(2)

Using the Recordset Object's Find Method

382

(5)

Exercises

387

(4)

The Selection Structure

391

(58)

Concept Lesson

392

(17)

Using the If...Then...Else Statement

392

(1)

Comparison Operators

393

(2)

UCase Function

395

(2)

Logical Operators

397

(2)

Nesting If...Then...Else Statements

399

(2)

Summary

401

(1)

Review Questions

402

(2)

Exercises

404

(5)

Excel Lesson: Using the Selection Structure in Excel

409

(16)

Viewing the Calculator Worksheet

410

(2)

The PublishObjects Collection and PublishObject Objects

412

(1)

The Add Method

412

(3)

Coding the PublishCalculator Procedure

415

(6)

Exercises

421

(4)

Word Lesson: Using the Selection Structure in Word

425

(16)

Viewing the Personal Assessment Document

426

(3)

The TableOfContents Collection and TableOfContents Objects

429

(1)

The Add Method

430

(1)

The Format Property

431

(1)

Coding the CreateToc Procedure

431

(4)

Exercises

435

(6)

Access Lesson: Using the Selection Structure in Access

441

(8)

Modifying the PaymentUpdate Procedure

441

(5)

Exercises

446

(3)

The Select Case Statement and the MSG Box Function

449

(60)

Concept Lesson

450

(16)

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Visual Basic for Applications

Summary

Table of Contents

Supplemental Materials