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

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

Card image cap
CutString3_Search

Using same code in CutString3, this will search for matching items. Searches ...

Card image cap
CutString3

Cuts a string from a larger one using separators.
Ex, CutString3("Will ...

Card image cap
Number_Formatted

Format the number as ' <1000 = 1,2,55, 85, 989 ' <1000000 = 1K, ...

Card image cap
ReplaceChars

Replaces all chars found in Chars_to_remove from String1 with Char_to_put One ...

Card image cap
Calendar, a pure-VBA userform (FrmCal)

VBA pure Calendar form, no outside lib needed Edit 2020-03-18: Enhance ...

FrmCal.zip

Card image cap
VBA Progressbar (Frm73)

Progress bar Frm73 or just simple message Zip file contains .frm and .frx ...

Frm73.zip

Card image cap
iShuffle + lShuffle

Generates a random number, integer or long