O'Reilly logo

Excel 2013 Power Programming with VBA by John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix A: VBA Statements and Functions Reference

This appendix contains a complete listing of all Visual Basic for Applications (VBA) statements (Table A-1) and built-in functions (Table A-2). For details, consult Excel's online help.

note.eps

Excel 2013 has no new VBA statements.

Table A-1: Summary of VBA Statements

Statement

Action

AppActivate

Activates an application window

Beep

Sounds a tone through the computer's speaker

Call

Transfers control to another procedure

ChDir

Changes the current directory

ChDrive

Changes the current drive

Close

Closes a text file

Const

Declares a constant value

Date

Sets the current system date

Declare

Declares a reference to an external procedure in a Dynamic Link Library (DLL)

DefBool

Sets the default data type to Boolean for variables that begin with specified letters

DefByte

Sets the default data type to Byte for variables that begin with specified letters

DefCur

Sets the default data type to Currency for variables that begin with specified letters

DefDate

Sets the default data type to Date for variables that begin with specified letters

DefDec

Sets the default data type to Decimal for variables that begin with specified letters

DefDbl

Sets the default data type to Double for variables that begin with specified letters

DefInt

Sets the default data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required