VBA 69 Visual Basic for Application (or macros) in most application. Code here can also be used in VBA-Excel

Card image cap
GenerateMemorablePassword

Returns a random password that is easier to remember, such as BONES or LAMOT. ...

Card image cap
FrmAbout

Display a string in a Userform as 'About' window, can display string or file by ...

FrmAbout.zip

Card image cap
FileDate_Formatted

Using FileDateTime to get file date

Card image cap
Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...

Card image cap
ComputerSN

Reads Serial number of the system, also can be used to return System name, ...

Card image cap
FindIn1DArray

Returns 1 if an item found in array, 0 if not

Card image cap
Numbers in Textbox

Force textbox to accept numbers only. Needs adjustments to work on VB6

Card image cap
RGB2Long

Converts Red, Green and Blue integers into RGB long value

Card image cap
RoundUp

Rounds a number up, like Excel function RoundUP

Card image cap
CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

Card image cap
CopyText2Clipboard

Copies text to clipboard using MSForms

Card image cap
ANStrColor2RGB + RGB2ANStrColor

Converts R:G:B into RGB value (as long) and RGB from long into R:G:B