A VBA Statements and Function 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.
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 |
| DefDbl | Sets the default data type to Double for variables that begin with specified letters |
| DefDec | Sets the default data type to Decimal for variables that begin with specified letters |
| DefInt | Sets the default data type to Integer for variables that begin with specified letters ... |
Get Excel 2016 Power Programming with VBA now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
