Repository files navigation

• Calendar constants
• Color constants
• Comparison constants
• Date constants
  • Day of Week
  • First Week Of Year
• Dir, GetAttr, and SetAttr constants

• AppActivate
• Beep
• Call
• ChDir
• ChDrive
• Close
• Const
• Date
• DeleteSetting
• Dim
• Do...Loop
• End
• Enum
• Erase
• Error
• Event
• Exit
• FileCopy
• For Each...Next
• For...Next
• Function
• Get
• GoSub...Return
• GoTo
• If...Then...Else
• Input #
• Kill
• Let
• Line Input #
• Load
• Lock, Unlock
• LSet
• Mid
• MkDir
• Name
• On Error
• On...GoSub, On...GoTo
• Open
• Option Base
• Option Compare
• Option Explicit
• Option Private
• Print #
• Private
• Property Get
• Property Let
• Property Set
• Public
• Put
• RaiseEvent
• Randomize
• ReDim
• Rem
• Reset
• Resume
• RmDir
• RSet
• SaveSetting
• Seek
• Select Case
• SendKeys
• Set
• SetAttr
• Static
• Stop
• Sub
• Time
• Type
• Unload
• While...Wend
• Width #
• With
• Write #

• Asc
• Chr
• Format
• Hex
• Oct
• Str
• Val

• Abs
• Atn
• Cos
• Exp
• Int, Fix
• Log
• Rnd
• Sgn
• Sin
• Sqr
• Tan

The followingconstants can be used anywhere in your code in place of the actual values.

VbCalendar

TheVbCalendar argument has the following values.

ColorConstants

TheColorConstants argument has the following values.

VbCompareMethod

TheVbCompareMethod argument has the following values.

The followingconstants can be used anywhere in your code in place of the actual values.

VbDayOfWeek

TheVbDayOfWeek argument has the following values.

VbFirstWeekOfYear

TheVbFirstWeekOfYear argument has the following values.

VbFileAttribute

TheVbFileAttribute argument has the following values.

OnlyVbNormal,vbReadOnly,vbHidden, andvbAlias are available on the Macintosh.

Activates an application window.

AppActivate

AppActivatetitle, [wait ]

Sounds a tone through the computer's speaker.

Beep

Beep

Transfers control to a Sub procedure, Function procedure, or dynamic-link library (DLL) procedure.

Call

[Call ]name [argumentlist ]

Changes the current directory or folder.

ChDir

ChDirpath

Changes the current drive.

ChDrive

ChDrivedrive

Concludes input/output (I/O) to a file opened by using the Open statement.

Close

Close [filenumberlist ]

Declaresconstants for use in place of literal values.

Const

[Public |Private ]Constconstname [Astype ]=expression

Sets the current system date#mmmm d, yyyy#.

Date

Date=date

Deletes a section or key setting from an application's entry in the Windowsregistry or (on the Macintosh) information in the application's initialization file.

DeleteSetting

DeleteSettingappname,section,key

Declaresvariables and allocates storage space.

DimDimWithEvents

Dim [WithEvents ]varname [( [subscripts ]) ] [As [New ]type ]

Repeats a block ofstatements while a condition isTrue or until a condition becomesTrue.

DoUntilLoopDoWhileLoop

Do [{While |Until}condition ]  [statements ]  [ExitDo ]  [statements ]Loop

Or,

DoLoopUntilDoLoopWhile

Do  [statements ]  [ExitDo ]  [statements ]Loop [{While |Until}condition ]

Ends a procedure or block.

EndEndFunctionEndIfEndPropertyEndSelectEndSubEndTypeEndWith

EndEndFunctionEndIfEndPropertyEndSelectEndSubEndTypeEndWith

Declares a type for an enumeration.

Enum

[Public |Private ]Enumnamemembername [=constantexpression ]membername [=constantexpression ]...EndEnum

Reinitializes the elements of fixed-sizearrays and releases dynamic-array storage space.

Erase

Erasearraylist

Simulates the occurrence of an error.

Error

Errorerrornumber

Declares a user-defined event.

Event

[Public ]Eventprocedurename [(arglist) ]

Exits a block of Do…Loop, For…Next, Function, Sub, or Property code.

ExitDoExitFoExitFuExitPrExitSu

ExitDoExitForExitFunctionExitPropertyExitSub

Copies a file.

FileCopy

FileCopysource,destination

Repeats a group ofstatements for each element in anarrays or collection.

ForEach

ForEachelementIngroup  [statements ]  [ExitFor ]  [statements ]Next [element ]

Repeats a group ofstatements a specified number of times.

ForNext

Forcounter=startToend [Stepstep ]  [statements ]  [ExitFor ]  [statements ]Next [counter ]

Declares the name, arguments, and code that form the body of aFunctionprocedure.

FunctionFunctionStatic

[Public |Private |Friend] [Static ]Functionname [(arglist) ] [Astype ]  [statements ]  [name=expression ]  [ExitFunction ]  [statements ]  [name=expression ]EndFunction

Reads data from an open disk file into a variable.

Get

Get [# ]filenumber, [recnumber ],varname

Branches to and returns from a subroutine within a procedure.

GoSub

GoSubline...lineline...Return

Branches unconditionally to a specified line within a procedure.

GoToline

GoToline

Conditionally executes a group ofstatements, depending on the value of an expression.

If

IfconditionThen [statements ] [Elseelsestatements ]Or,IfconditionThen  [statements ][ElseIfcondition-nThen  [elseifstatements ]][Else  [elsestatements ]]EndIf

Loads an object but doesn't show it.

Load

Loadobject

Reads data from an open sequential file and assigns the data to variables.

Input

Input#filenumber,varlist

Deletes files from a disk.

Kill

Killpathname

Assigns the value of an expression to a variable or property.

Let

[Let ]varname=expression

Reads a single line from an open sequential file and assigns it to a String variable.

LineInput

LineInput#

Controls access by other processes to all or part of a file opened by using the Open statement.

LockUnlock

Lock [# ]filenumber, [recordrange ]Unlock [# ]filenumber, [recordrange ]

Left aligns a string within a string variable, or copies a variable of oneuser-defined type to another variable of a different user-defined type.

LSet

LSetstringvar=stringLSetvarname1=varname2

Replaces a specified number of characters in aVariant (String) variable with characters from another string.

Mid

Mid(stringvar,start, [length ])=string

Creates a new directory or folder.

MkDir

MkDirpath

Renames a disk file, directory, or folder.

Name

NameoldpathnameAsnewpathname

Enables an error-handling routine and specifies the location of the routine within a procedure; can also be used to disable an error-handling routine.

OnErrorGoOnErrorRe

OnErrorGoTo0OnErrorGoTolineOnErrorResumeNext

Branch to one of several specified lines, depending on the value of an expression.

OnGoSubOnGoTo

OnexpressionGoSubdestinationlistOnexpressionGoTodestinationlist

Enables input/output (I/O) to a file.

Open

OpenpathnameFormode [Accessaccess ] [lock ]As [# ]filenumber [Len=reclength ]

Used at the module level to declare the default lower bound for array subscripts.

OptionBa

OptionBase{0 |1}

Used at the module level to declare the default comparison method to use when string data is compared.

OptionCo

OptionCompare{Binary |Text |Database}

Used at the module level to force explicit declaration of all variables in that module.

OptionEx

Option Explicit

When used in host applications that allow references across multiple projects,Option Private Module prevents a module's contents from being referenced outside its project. In host applications that don't permit such references, for example, standalone versions of Visual Basic,Option Private has no effect.

OptionPr

OptionPrivateModule

Writes display-formatted data to a sequential file.

Print#

Print#filenumber, [outputlist ]

Used at the module level to declare private variables and allocate storage space.

PrivatePrivateWith

Private [WithEvents ]varname [( [subscripts ]) ] [As [New ]type ]

Declares the name, arguments, and code that form the body of aProperty procedure, which gets the value of a property.

PropertyGetPropertyGetStatic

[Public |Private |Friend ] [Static ]PropertyGetname [(arglist) ] [Astype ]  [statements ]  [name=expression ][ExitProperty ]  [statements ]  [name=expression ]EndProperty

Declares the name, arguments, and code that form the body of aProperty procedure, which assigns a value to a property.

PropertyLetPropertyLetStatic

[Public |Private |Friend ] [Static ]PropertyLetname( [arglist ],value)  [statements ]  [ExitProperty ]  [statements ]EndProperty

Declares the name, arguments, and code that form the body of aProperty procedure, which sets a reference to an object.

PropertySetPropertySetStatic

[Public |Private |Friend ] [Static ]PropertySetname( [arglist ],reference)  [statements ]  [ExitProperty ]  [statements ]EndProperty

Used at the module level to declare public variables and allocate storage space.

PublicPublicWith

Public [WithEvents ]varname [( [subscripts ]) ] [As [New ]type ]

Writes data from a variable to a disk file.

Put

Put [# ]filenumber, [recnumber ],varname

Fires an event declared at the module level within a class, form, or document.

RaiseEvent

RaiseEventeventname [(argumentlist) ]

Initializes the random-number generator.

Randomize

Randomize [number ]

Used at the procedure level to reallocate storage space for dynamic array variables.

ReDim

ReDim [Preserve ]varname(subscripts)

Used to include explanatory remarks in a program.

Rem

Remcomment

Closes all disk files opened by using the Open statement.

Reset

Reset

Removes an existing directory or folder.

ResumeResumeNeResumeLi

Resume [0 ]ResumeNextResumeline

Removes an existing directory or folder.

RmDir

RmDirpath

Right aligns a string within a string variable, or copies a variable of one user-defined type to another variable of a different user-defined type.

RSet

RSetstringvar=stringRSetvarname1=varname2

Saves or creates an application entry in the application's entry in the Windows registry or (on the Macintosh) information in the application's initialization file.

SaveSetting

SaveSettingappname,section,key,setting

The root of these registry settings is:Computer\HKEY_CURRENT_USER\Software\VB and VBA Program Settings.

Sets the position for the next read/write operation within a file opened by using the Open statement.

Seek

Seek [# ]filenumber,position

Executes one of several groups of statements, depending on the value of an expression.

SelectCase

SelectCasetestexpression[Caseexpressionlist-n  [statements-n ]][CaseElse   [elsestatements ]]EndSelect

Sends one or more keystrokes to the active window as if typed at the keyboard.

SendKeys

SendKeys [# ]filenumber,position

Assigns an object reference to a variable or property.

Set

Setobjectvar={[New ]objectexpression |Nothing}

Sets attribute information for a file.

SetAttr

SetAttrpathname,attributes

Used at the procedure level to declare variables and allocate storage space. Variables declared with theStatic statement retain their values as long as the code is running.

Static

Staticvarname [( [subscripts ]) ] [As [New ]type ]

Suspends execution.

Stop

Stop

Declares the name, arguments, and code that form the body of aSub procedure.

SubSubStatic

[Private |Public |Friend ] [Static ]Subname [(arglist) ]  [statements ]  [ExitSub ]  [statements ]EndSub

Sets the system time.#hh:mm:ss AM/PM#

Time

Time=time

Used at the module level to define a user-defined data type containing one or more elements.

Type

[Private |Public ]Typevarnameelementname [( [subscripts ]) ]Astype  [elementname [( [subscripts ]) ]Astype ]...EndType

Removes an object from memory.

Unload

Unloadobject

Removes an object from memory.

WhileWend

Whilecondition  [statements ]Wend

Assigns an output line width to a file opened by using the Open statement.

Width

Width#filenumber,width

Executes a series of statements on a single object or a user-defined type.

With

Withobject  [statements ]EndWith

Writes data to a sequential file.

Write

Write#filenumber, [outputlist ]

Returns an Integer representing the character code corresponding to the first letter in a string.

Asc

Asc(string)

Returns a String containing the character associated with the specified character code.

Chr

Chr(charcode)

Returns a Variant (String) containing an expression formatted according to instructions contained in a format expression.

Format

Format(Expression, [Format ], [FirstDayOfWeek ], [FirstWeekOfYear ])

Returns a Variant (String) containing an expression formatted according to instructions contained in a format expression.

Hex

Hex(number)

Returns a Variant (String) representing the octal value of a number.

Oct

Oct(number)

Returns a Variant (String) representation of a number.

Str

Str(number)

Returns the numbers contained in a string as a numeric value of appropriate type.

Val

Val(string)

Returns a value of the same type that is passed to it specifying the absolute value of a number.

Abs

Abs(number)

Returns a Double specifying the arctangent of a number.

Atn

Atn(number)

Returns a Double specifying the cosine of an angle.

Cos

Cos(number)

Returns a Double specifying e (the base of natural logarithms) raised to a power.

Exp

Exp(number)

Returns a Double specifying e (the base of natural logarithms) raised to a power.

IntFix

Int(number)Fix(number)

Returns a Double specifying the natural logarithm of a number.

Log

Log(number)

Returns a Single containing a pseudo-random number.

Rnd

Rnd [(Number) ]

Returns a Variant (Integer) indicating the sign of a number.

Sgn

Sgn(number)

Returns a Double specifying the cosine of an angle.

Sin

Sin(number)

Returns a Double specifying the sine of an angle.

Sqr

Sqr(number)

Returns a Double specifying the tangent of an angle.

Tan

Tan(number)

• Initial release of MicroBeaut VBA Snippets

• Changed package description
• Revised statements
• Added new statements

• Changed the prefix for,
  • Dim WithEvent
  • On Error *
  • Private WithEvent
  • Public WithEvent

• Removed statementsIf...Then..Exit inside,
  • Do...Loop
  • For Each...Next
  • For...Next
  • Function
  • If...Then...Else
• Updated descriptions
• Added new statements
• Added Conversion functions
• Added Math functions

• Fixed package not updated

• Added VBA Constants

MIT License

Copyright © 2023 MicroBeaut