VBA 127

Visual Basic for Application (or macros) in most applications. Code here can also be used in VBA-Excel
  2. Languages
  3. VBA
Sorted from new to old.
Card image
Numbers in Textbox

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

2018Jun6
Card image
RGB2Long

Converts Red, Green and Blue integers into RGB long value

2018Jun2
Card image
RoundUp

Rounds a number up, like Excel function RoundUP

2018Jun2
Card image
CutRightString

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

2018Jun2
Card image
CopyText2Clipboard

Copies text to clipboard using MSForms

2018May30
Card image
ANStrColor2RGB + RGB2ANStrColor

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

2018May30
Card image
CutString3_Search

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

2018May29
Card image
CutString3

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

2018May29
Card image
Number_Formatted

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

2018May26
Card image
ReplaceChars

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

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

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

2018May16
Card image
VBA Progressbar (Frm73)

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

2018May16
Card image
iShuffle + lShuffle

Generates a random number, integer or long

2018May13
Card image
ASCII_Read + ASCII_Save

Reads and saves text file giving its full name Used a lot in my tools, very ...

2018Apr21
Card image
ANStrList functions

Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...

2018Apr14
12...78