Functions

 


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