V


Value property, 120–121, 122

vs. Value2 property, 122

variables, 180

with assigned values, 238

declaring, 123, 180

Empty value, 323

module-level, 278

naming, 143

Nothing value, 323

public, 278

as ranges, 107, 115

spelling errors, checking for, 246

VBA

apostrophes beginning lines in. see comments

green lines in. see comments vs. macros, 2–4

.NET Framework and, 4

object model. see object model

selecting lines in, 17

statements. see statements

vbCrLf constant, 258

View Code button, 267

views

custom, creating, 317–320

switching between, 320–321

viruses, prevention of, 12, 28

Visual Basic editor

Immediate window, 73

opening, 73

windows in, 76–77

volatile functions

defined, 242

recalculating, 242

when to use, 243



Microsoft Office Excel 2007 Visual Basic for Applications Step by Step
Microsoft Excel 2002 Visual Basic for Applications Step by Step (Step by Step (Microsoft))
ISBN: 0735613591
EAN: 2147483647
Year: 2004
Pages: 99
Authors: Reed Jacobsen

Similar book on Amazon
Excel 2003 Power Programming with VBA (Book & CD-ROM)
Excel 2003 Power Programming with VBA (Book & CD-ROM)
Microsoftu00ae Office Excelu00ae 2007 Visual Basicu00ae for Applications Step by Step (BPG-step by Step)
Microsoftu00ae Office Excelu00ae 2007 Visual Basicu00ae for Applications Step by Step (BPG-step by Step)
Excel 2003 Formulas
Excel 2003 Formulas
Writing Excel Macros with VBA, 2nd Edition
Writing Excel Macros with VBA, 2nd Edition

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net