Shared Flashcard Set

Details

VBA Programming
VBA Statements
75
Computer Science
Graduate
02/09/2017

Additional Computer Science Flashcards

 


 

Cards

Term
AppActivate
Definition
Activates an application window
Term
Beep
Definition
Sounds a tone via the computer
Term
Call
Definition
Transfers control to another procedure
Term
ChDir
Definition
Changes the current directory
Term
ChDrive
Definition
Changes the current drive
Term
Close
Definition
Closes a text file
Term
Const
Definition
Declares a constant value
Term
Date
Definition
Sets the current system date
Term
Declare
Definition
Declares a reference to an external procedure in a Dynamic Link Library (DLL)
Term
DeleteSetting
Definition
Deletes a section or key setting from an application
Term
Dim
Definition
Declares variables and (optionally) their data types
Term
Do-Loop
Definition
Loops through a set of instructions
Term
End
Definition
Used by itself, exits the program; also used to end a block of statements that begin with If, With, Sub, Function, Property, Type, or Select
Term
Erase
Definition
Re-initializes an array
Term
Error
Definition
Simulates a specific error condition
Term
Exit Do
Definition
Exits a block of Do-Loop code
Term
Exit For
Definition
Exits a block of For-Next code
Term
Exit Function
Definition
Exits a Function procedure
Term
Exit Property
Definition
Exits a property procedure
Term
Exit Sub
Definition
Exits a subroutine procedure
Term
FileCopy
Definition
Copies a file
Term
For Each-Next
Definition
Loops through a set of instructions for each member of a collection
Term
For-Next
Definition
Loops through a set of instructions a specific number of times
Term
Function
Definition
Declares the name and arguments for a Function procedure
Term
Get
Definition
Reads data from a text file
Term
GoSub
Definition
Branches to and returns from a procedure
Term
GoTo
Definition
Branches to a specified statement within a procedure
Term
If-Then-Else
Definition
Processes statements conditionally (the Else part is optional)
Term
Input #
Definition
Reads data from a sequential text file
Term
Kill
Definition
Deletes a file
Term
Let
Definition
Assigns the value of an expression to a variable or property
Term
Line Input #
Definition
Reads a line of data from a sequential text file
Term
Load
Definition
Loads an object but doesn
Term
Lock
Definition
Controls access to a text file
Term
Mid
Definition
Replaces characters in a string with other characters
Term
MkDir
Definition
Creates a new directory
Term
Name
Definition
Renames a file or directory
Term
On Error
Definition
Gives specific instructions for what to do in the case of an error
Term
On
Definition
Branches, based on a condition
Term
On
Definition
Branches, based on a condition
Term
Open
Definition
Opens a text file
Term
Option Base
Definition
Changes the default lower limit for arrays
Term
Option Compare
Definition
Declares the default comparison mode when comparing strings
Term
Option Explicit
Definition
Forces declaration of all variables in a module
Term
Option Private
Definition
Indicates that an entire module is Private
Term
Print #
Definition
Writes data to a sequential file
Term
Private
Definition
Declares a local array or variable
Term
Property Get
Definition
Declares the name and arguments of a Property Get procedure
Term
Property Let
Definition
Declares the name and arguments of a Property Let procedure
Term
Property Set
Definition
Declares the name and arguments of a Property Set procedure
Term
Public
Definition
Declares a public array or variable
Term
Put
Definition
Writes a variable to a text file
Term
RaiseEvent
Definition
Fires a user-defined event
Term
Randomize
Definition
Initializes the random number generator
Term
ReDim
Definition
Changes the dimensions of an array
Term
Rem
Definition
Specifies a line of comments (same as an apostrophe [
Term
Reset
Definition
Closes all open text files
Term
Resume
Definition
Resumes execution when an error-handling routine finishes
Term
RmDir
Definition
Removes an empty directory
Term
SaveSetting
Definition
Saves or creates an application entry in the Windows Registry
Term
Seek
Definition
Sets the position for the next access in a text file
Term
Select Case
Definition
Processes statements conditionally
Term
SendKeys
Definition
Sends keystrokes to the active window
Term
Set
Definition
Assigns an object reference to a variable or property
Term
SetAttr
Definition
Changes attribute information for a file
Term
Static
Definition
Declares variables at the procedure level so that the variables retain their values as long as the code is running and the project hasn
Term
Stop
Definition
Pauses the program
Term
Sub
Definition
Declares the name and arguments of a Sub procedure
Term
Time
Definition
Sets the system time
Term
Type
Definition
Defines a custom data type
Term
Unload
Definition
Removes an object from memory
Term
While
Definition
Loops through a set of instructions as long as a certain condition remains true
Term
Width #
Definition
Sets the output line width of a text file
Term
With
Definition
Allows a shorthand way of accessing multiple properties for an object
Term
Write #
Definition
Writes data to a sequential text file
Supporting users have an ad free experience!