VBA 126

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

Extract a full number from string block having 1 or more full numbers. Like ...

Card image
CountNumbers_inString

Returns how many numbers found inside a text

Card image
ANmaSearch_SpaceFriends and LeftSpaceFriends

Searches for string inside string covering multiple possibilities for space ...

Card image
ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

Card image
ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

Card image
QuarterNumber_FromDate

Returns the number of quarter from a date

Card image
ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

Card image
DecimalPlaces

Returns how many decimal places the number have

Card image
IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

Card image
ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

Card image
ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

Card image
ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Card image
ANmaSearch_AposFriends

Searches for string inside string with apostrophe possibility (or as I call ...

Card image
ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

Card image
CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Card image
Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...