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

  2. Languages
  3. VBA
Card image cap
ANmaSpecialFolders

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

Fri 4AM
Card image cap
QuarterNumber_FromDate

Returns the number of quarter from a date

Fri 3AM
Card image cap
ANStr_Add10IfNotBlank_NorNA

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

Wed 9AM
Card image cap
DecimalPlaces

Returns how many decimal places the number have

Wed 9AM
Card image cap
IfString_StartsWith_AndOr_EndsWith

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

Jul18
Card image cap
ANmaSearch_QuoteFriends

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

Jul13
Card image cap
ANmaReplace_Occurrence

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

Jul13
Card image cap
ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Jul13
Card image cap
ANmaSearch_AposFriends

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

Jul11
Card image cap
ANmaSearch_AmpFriends

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

Jul7
Card image cap
CalculateQuarterText

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

Jun10
Card image cap
Q_NoOfdays

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

Jun9