| Error handling |
Try..Catch |
| Flow of control |
Call, Do...Loop, Exit, For...Next, For Each...Next, If...Then...Else, Select Case, While...Wend, With, End |
| Other |
Debugger, Execute, HTML, JavaScript, Print, Sleep, SQL, WaitCursor |
| Structure |
Function, Sub |
| Variables |
Const, Dim, Erase, Option, Explicit, Private, Public, ReDim, Rem, Set |
| Arithmetic |
Abs, Asc, Atn, Cos, Exp, Fix, Int, Log, Rnd, Round, Sgn, Sin, Sqr, Tan |
| Conversion |
Cbool, Cbyte, Ccur, Cdate, CDbl, Chr, Cint, CLng, CSng, CStr, Hex, Oct |
| Date/Time |
Date, DateAdd, DateDiff, DateSerial, Date, DatePart, Value, Day, Hour, Minute, Month, MonthName, Now, Second, Space, Time, TimeSerial Time,Value, Weekday, WeekdayName, Year |
| Formatting |
Escape, FormatCurrency, FormatDateTime, FormatNumber, FormatPercent, Unescape |
| Input/Output |
InputBox, MsgBox |
| Other |
Eval, SetTimeOut, SQLOpenDatabase, SysInfo |
| String Handling |
Filter, InStr, InStrRev, Join, Lcase, Left, Len, Ltrim, Mid, Replace, Right, Rtrim, Split, StrComp, StrReverse, String, Trim, UCase |
| Variable Handling |
Array, IsArray, IsDate, IsEmpty, IsNull, IsNumeric, IsObject, Lbound, TypeName, Ubound, VarType |
| Color |
vbBlack, vbRed, vbGreen, vbYellow, vbBlue, vbMagenta, vbCyan, vbWhite |
| Comparison |
vbBinaryCompare, vbTextCompare |
| Date/Time |
vbSunday, vbMonday, vbTuesday, vbWednesday, vbThursday, vbFriday, vbSaturday, vbFirstJan1, vbFirstFourDays, vbFirstFullWeek, vbUseSystem, vbUseSystemDayOfWeek |
| Date Format |
vbGeneralDate, vbLongDate, vbShortDate, vbLongTime, vbShortTime |
| MsgBox |
display: vbOKOnly,vbOKCancel, vbAbortRetryIgnore, vbYesNoCancel, vbYesNo, vbRetryCancel, vbCritical, vbQuestion, vbExclamation, vbInformation, vbDefaultButton1, vbDefaultButton2, vbDefaultButton3, vbDefaultButton4, vbApplicationModal, vbSystemModal
return: vbOK, vbCancel, vbAbort, vbRetry, vbIgnore, vbYes, vbNo |
| String |
vbCr, vbCrLf, vbFormFeed, vbLf, vbNewLine, vbNullChar, vbNullString, vbTab, vbVerticalTab |
| VarType |
bEmpty, vbNull, vbInteger, vbLong, vbSingle, vbDouble, vbCurrency, vbDate, vbString, vbObject, vbError, vbBoolean, vbVariant, vbDataObject, vbDecimal, vbByte, vbArray |
| Other |
CurrentPath, NSBVersion |
| Arithmetic |
Addition (+), Division (/), Exponentiation (^), Mod, Muliplication (*), Negation (-), Subtraction (-) |
| Boolean |
And, Eqv, Imp, Not, Or, Is, =, <, >, Xor |
| String |
Concatenation (&) |
| Audio |
Play sounds. |
| CheckBox |
One or more checkboxes in a column. |
| ComboBox |
Displays a picker for different values. |
| CommandButton |
Standard command button |
| Grid |
Displays data in a table. |
| HTMLview |
Displays HTML formatted text. |
| Image |
Displays an image file. |
| Label |
Standard Label |
| Menu |
Displays a list of items to go to. |
| MultiInput |
One or more input fields in a column. |
| OptionButton |
Displays one or more mutually exclusive choices. |
| Picturebox |
General purpose object for buttons, pictures, text and graphics |
| TextArea |
Multi line input field |
| TextBox |
Single line input field |
| TitleBar |
Top bar on screen. Can include buttons. |
| Video |
Display video that is part of the app or on a website. |