Shared Flashcard Set

Details

VBA Programming
VBA Functions
116
Computer Science
Graduate
02/09/2017

Additional Computer Science Flashcards

 


 

Cards

Term
Abs
Definition
Returns the absolute value of a number
Term
Array
Definition
Returns a variant that contains an array
Term
Asc
Definition
Converts the first character of string to its ASCII value
Term
Atn
Definition
Returns the arctangent of a number
Term
CBool
Definition
Converts an expression to Boolean data type
Term
CByte
Definition
Converts an expression to byte data type
Term
CCur
Definition
Converts an expression to currency data type
Term
CDate
Definition
Converts an expression to date data type
Term
CDbl
Definition
Converts an expression to double data type
Term
CDec
Definition
Converts an expression to decimal data type
Term
Choose
Definition
Selects and returns a value from a list of arguments
Term
Chr
Definition
Converts an ANSI value to a character
Term
CInt
Definition
Converts an expression to integer data type
Term
CLng
Definition
Converts an expression to long data type
Term
Cos
Definition
Returns the cosine of a number
Term
CreateObject
Definition
Creates an OLE Automation object
Term
CSng
Definition
Converts an expression to single data type
Term
CStr
Definition
Converts an expression to string data type
Term
CurDir
Definition
Returns the current path
Term
CVar
Definition
Converts an expression to variant data type
Term
CVDate
Definition
Converts an expression to date data type
Term
CVErr
Definition
Returns a user-defined error type
Term
Date
Definition
Returns the current system date
Term
DateAdd
Definition
Returns a date with a specific date interval added to it
Term
DateDiff
Definition
Returns the difference between two dates as a time interval
Term
DatePart
Definition
Returns an integer containing a specific part of a date
Term
DateSerial
Definition
Returns a date for a specified year, month, and day
Term
DateValue
Definition
Converts a string to date
Term
Day
Definition
Returns the day of the month of a date
Term
Dir
Definition
Returns the name of a file or directory that matches a pattern
Term
DoEvents
Definition
Yields execution so the operating system can process other events
Term
EOF
Definition
Returns True if the end of a text file has been reached
Term
Error
Definition
Returns the error message that corresponds to an error number
Term
Exp
Definition
Returns the base of the natural logarithms (e) raised to a power
Term
FileAttr
Definition
Returns the file mode for a text file
Term
FileDateTime
Definition
Returns the date and time when a file was last modified
Term
FileLen
Definition
Returns the number of bytes in a file
Term
Fix
Definition
Returns the integer portion of a number
Term
Format
Definition
Returns an expression in a particular format
Term
FormatCurrency
Definition
Returns a number as a string, formatted as currency
Term
FormatDateTime
Definition
Returns a number as a string, formatted as a date and/or time
Term
FormatNumber
Definition
Returns a number as a formatted string
Term
FormatPercent
Definition
Returns a number as a string, formatted as a percentage
Term
FreeFile
Definition
Returns the next file number available for use by the Open statement
Term
GetAll
Definition
Returns a list of key settings and their values (originally created with SaveSetting) from an application
Term
GetAttr
Definition
Returns a code representing a file attribute
Term
GetObject
Definition
Retrieves an OLE Automation object from a file
Term
GetSetting
Definition
Returns a key setting value from an application
Term
Hex
Definition
Converts from decimal to hexadecimal
Term
Hour
Definition
Returns the hour of a time
Term
IIf
Definition
Returns one of two parts, depending on the evaluation of an expression
Term
Input
Definition
Returns a specific number of characters from an open text file
Term
InputBox
Definition
Displays a box to prompt a user for input, and returns the value entered
Term
InStr
Definition
Returns the position of a string within another string
Term
InStrRev
Definition
Returns the position of a string within another string, beginning at the back end of the string
Term
Int
Definition
Returns the integer portion of a number
Term
IsArray
Definition
Returns True if a variable is an array
Term
IsDate
Definition
Returns True if a variable is a date
Term
IsEmpty
Definition
Returns True if a variable has not been initialized
Term
IsError
Definition
Returns True if an expression is an error value
Term
IsMissing
Definition
Returns True if an optional argument was not passed to a procedure
Term
IsNull
Definition
Returns True if an expression contains no valid data
Term
IsNumeric
Definition
Returns True if an expression can be evaluated as a number
Term
IsObject
Definition
Returns True if an expression references an OLE Automation object
Term
Join
Definition
Returns a string created by joining a number of substrings contained in an array
Term
LBound
Definition
Returns the lower bound of an array
Term
LCase
Definition
Returns a string converted to lowercase
Term
Left
Definition
Returns a specified number of characters from the left of a string
Term
Len
Definition
Returns the length of a string, in characters
Term
Loc
Definition
Returns the current read or write position of a text file
Term
LOF
Definition
Returns the number of bytes in an open text file
Term
Log
Definition
Returns the natural logarithm of a number
Term
LTrim
Definition
Returns a copy of a string with no leading spaces
Term
Mid
Definition
Returns a specified number of characters from a string
Term
MidB
Definition
Returns a specified number of bytes from a specified position in a string string
Term
Minute
Definition
Returns the minute of a time
Term
Month
Definition
Returns the month of a date
Term
MonthName
Definition
Returns a string indicating the specified month
Term
MsgBox
Definition
Displays a modal message box and returns the ID of the button clicked
Term
Now
Definition
Returns the current system date and time
Term
Oct
Definition
Converts from decimal to octal
Term
Replace
Definition
Returns a string in which one substring is replaced with another
Term
RGB
Definition
Returns a number representing an RGB color value
Term
Right
Definition
Returns a specified number of characters from the right of a string
Term
Rnd
Definition
Returns a random number between 0 and 1
Term
Round
Definition
Rounds a number to a specific number of decimal places
Term
RTrim
Definition
Returns a copy of a string with no trailing spaces
Term
Second
Definition
Returns the second of a time
Term
Seek
Definition
Returns the current position in a text file
Term
Sgn
Definition
Returns an integer that indicates the sign of a number
Term
Shell
Definition
Runs an executable program
Term
Sin
Definition
Returns the sine of a number
Term
Space
Definition
Returns a string with a specified number of spaces
Term
Split
Definition
Returns an array consisting of a number of substrings
Term
Sqr
Definition
Returns the square root of a number
Term
Str
Definition
Returns a string representation of a number
Term
StrComp
Definition
Returns a value indicating the result of a string comparison
Term
StrConv
Definition
Returns a string variant converted as specified
Term
String
Definition
Returns a repeating character or string
Term
StrReverse
Definition
Returns the characters of a string in reverse order
Term
Switch
Definition
Evaluates a list of expressions and returns a value associated with the first expression in the list that is True
Term
Tab
Definition
Positions output in an output stream
Term
Tan
Definition
Returns the tangent of a number
Term
Time
Definition
Returns the current system time
Term
Timer
Definition
Returns the number of seconds since midnight
Term
TimeSerial
Definition
Returns the time for a specified hour, minute, and second
Term
TimeValue
Definition
Converts a string to a time serial number
Term
Trim
Definition
Returns a string without leading and spaces and replaces multiple spaces with a single space
Term
TypeName
Definition
Returns a string that describes the data type of a variable
Term
UBound
Definition
Returns the upper bound of an array
Term
UCase
Definition
Converts a string to uppercase
Term
Val
Definition
Returns the numbers contained in a string
Term
VarType
Definition
Returns a value indicating the subtype of a variable
Term
Weekday
Definition
Returns a number representing a day of the week
Term
Weekday Name
Definition
Returns a string indicating the specified weekday
Term
Year
Definition
Returns the year of a date
Supporting users have an ad free experience!