Category | Actions | Functions |
Converting | ANSI value to string | Chr, Chr$ |
Decimal numbers to other | Bin, Bin$, Hex, Hex$, Oct, Oct$ | |
Date to string | FormatDateTime | |
Number to string | Format, Format$, FormatNumber, Str, Str$ | |
One numeric data type to another | CBool, CByte, CDbl, CInt, CLng, CSng, CStr, CVar, CDate, CVDate, Fix, Int | |
String to ASCII value | Asc | |
String to number | Val |
Date/time | Get current date or time | Date, Now, Time, Timer |
Error trapping | Get error message | Error$ |
Get error-status data | Err, Erl |
File I/O |
Control output appearance |
Spc, Tab |
Get information about a file | EOF, FileAttr, FileDateTime, FileLen, FreeFile, Loc, LOF, Seek | |
Manage directories | CurDir, CurDir$, Dir | |
Read from a file | Input, Input$ | |
Get file attribute | GetAttr |
Math |
General calculations |
Exp, Log, Sqr |
Generate random numbers | Rnd | |
Get absolute value | Abs | |
Get the sign of an expression | Sgn | |
Numeric conversion | Fix, Int, Round | |
Trigonometry | Atn, Cos, Sin, Tan |
Strings | Compare two strings | StrComp |
Convert to lowercase or uppercase letters | LCase, LCase$, UCase, UCase$ | |
Create strings of repeating characters | Space, Space$, String, String$ | |
Get the length of a string | Len | |
Format strings | Format, Format$ | |
Manipulate strings | InStr, Left, Left$, LTrim, LTrim$, Mid, Mid$, Right, Right$, RTrim, RTrim$, Trim, Trim$ | |
Work with ASCII and ANSI values | Asc, Chr, Chr$ |
Variables and constants | Get information about a variable | IsDate, IsEmpty, IsNull, IsNumeric, VarType |
Miscellaneous | Run other programs | Shell |
Show input box dialog or message box dialog | InputBox, InputBox$, MsgBox | |
Show open/save dialogs | GetOpenFileName, GetSaveFileName |
Index | Alphabetical list of functions |