VBA 148

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

Sorted from new to old.

FrmAbout

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

2018Jun11

FileDate_Formatted

Using FileDateTime to get file date

2018Jun10

Filter_GotoItem

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

2018Jun7

ComputerSN

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

2018Jun6

FindIn1DArray

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

2018Jun6

Numbers in Textbox

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

2018Jun6

RGB2Long

Converts Red, Green and Blue integers into RGB long value

2018Jun2

RoundUp

Rounds a number up, like Excel function RoundUP

2018Jun2

CutRightString

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

2018Jun2

CopyText2Clipboard

Copies text to clipboard using MSForms

2018May30

ANStrColor2RGB + RGB2ANStrColor

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

2018May30

CutString3_Search

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

2018May29

CutString3

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

2018May29

Number_Formatted

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

2018May26

ReplaceChars

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

2018May26

Calendar, a pure-VBA userform (FrmCal)

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

2018May16

1 2 ...9 10