Functions and statements - Quick reference
- Flow of control
- Goto, End, OnError, Stop, Do...Loop, Exit Loop, For...Next, Exit
For, If..Then..Else...End If, Stop, While...Wend, Select Case
- Converting
- Chr, Hex, Oct, Str, CDbl, CInt, Clng, CSng, CStr, CVar, CVDate,
Asc, Val, Date, DateSerial, DateValue, Format, Fix, Int, Day, Weekday,
Month, Year, Hour, Minute, Second, TimeSerial, TimeValue
- Dialog
- Text, TextBox, ListBox, DropList, ComboBox, CheckBox, OKButton,
BeginDialog, EndDialog, OptionGroup, OKButton, CancelButton, PushButton,
Picture, GroupBox, Multi-line TextBox
- File I/O
- FileCopy, ChDir, ChDrive, CurDir, CurDir, MkDir,RmDir, Open, Close,
Print #, Kill, FreeFile, LOF, FileLen, Seek, EOF, Write #, Input,
Line Input, Dir, Name, GetAttr, SetAttr, Dir, Get, Put
- Math
- Exp, Log, Sqr, Rnd, Abs, Sgn, Atn, Cos, Sin, Tan, Int, Fix
- Procedures
- Call, Declare, Function, End Function, Sub, End Sub, Exit, Global
- Strings
- Let, Len, InStr, Left, Mid, Asc, Chr, Right, LCase, Ucase, InStr,
LTrim, RTrim, Trim, Option Compare, Len, Space, String, StrComp Format
- Variables and constants
- Dim, IsNull, IsNumeric,VarType, Const, IsDate, IsEmpty, IsNull,
Option Explicit, Global, Static
- Error trapping
- On Error, Resume
- Date/Time
- Date, Now, Time, Timer
- DDE
- DDEInitiate, DDEExecute, DDETerminate
- Arrays
- Option Base, Option Explicit, Static, Dim, Global, Lbound, Ubound,
Erase, ReDim
- Miscellaneous
- SendKeys, AppActivate, Shell, Beep, Rem, CreateObject, GetObject,
Randomize