• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Choosing the Right VBA Functi... > Using the Is Functions for Flawless ...

Using the Is Functions for Flawless Processing

All functions are prone to errors if you don’t reference the right type of data. Most of these errors can be avoided by a simple check using one of VBA’s many Is functions:

  • IsArray— Tests for an array

  • IsDate— Tests for a valid date value

  • IsEmpty— Determines whether variable has been initialized (by having stored a value)

  • IsError— Determines whether an expression is a valid error value

  • IsMissing— Determines whether an optional argument has been passed to a procedure

  • IsNull— Determines whether an expression contains a Null value

  • IsNumeric— Determines whether an expression can be evaluated as a valid number

  • IsObject— Indicates whether a variable contains a reference to an object


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint