VBA 150

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

Sorted from new to old.

ListItemText_to_ListIndex

Finds the index of an item in listbox (or combobox) It searches for that item ...

2025Mar24

NumberBeforeString_HTML2

Cuts a number that would be found 2 words before certain word inside a block ...

2025Mar20

TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

2025Mar16

VBInstr_SpaceFriends_BetweenHTMLTags

Searches for string inside string with multiple possibilities, returns ...

2025Mar13

ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

2025Mar10

PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

2025Feb1

ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

2025Jan8

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

VBInstr_Any

Returns the index where any of the words from AnStrSearchFor found in SearchIn ...

2024Nov17

RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). The pattern ...

2024Nov10

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

2024Sep5

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

2024Sep3

CutString12

Cuts string between two numbers that found inside string. Like extract the ...

2024Aug22

IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

2024Aug21

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20

1 2 ...9 10