Codes Required
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
MatchIfUp or MatchIfRev
Searching for an item in a column from bottom to top. Will search for item in ...
Apr8
ContainerHTMLTag_ReturnBlock
Returns the full string starting from open tag of container where LocationIndex ...
Apr3
Between2int and Between2intinc
Checks if number between two numbers, with or without considering those numbers. ...
Mar23
NumberNumberNumber
Finds 3 numbers in a string by ignoring characters between them. ' example ...
Mar2
HTML_InsideTag_ByIndex
Checks if LocIndex is found between open and close of HTMLTag or between close ...
Feb28
CutString_ReverseFrom
Returns full string starting from the point of LocIndex minus back where we ...
Feb27
ReplaceChars
Replaces all chars found in Chars_to_remove from String1 with Char_to_put One ...
2018May26
NameSilo_APICall_ListPrices
Downloads list of domains and prices for register, renew or transfer into ...
2018May25
DownloadFile
Download a file from URL from inside Excel into certain path, returns blank if ...
2018May22
FrmLarge v3
Shows an image after clicking on its thumbnail, like in web applications Can ...
2018May20
Calendar, a pure-VBA userform (FrmCal)
VBA pure Calendar form, no outside lib needed Edit 2020-03-18: Enhance ...
2018May16
ANStrList functions
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
DB_SettingRead + DB_SettingSave + ...
Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...
2018Apr14
Similar codes
ANStrRead + ANStrSave + ANStrSearch
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14
CreateList_Matching
Creates list of items found in rows, where these rows match a value in another ...
2020May13
ANStrList functions
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
ANStrFind_AndOrAdd
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
Dec19
Frm6 - ANmaMultiSelect
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator
2018Apr23
CreateUniqueList
Create list of unique items from a column into another column This is similar ...
2022Apr26
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Dark bootstrap5 css
Css and scss for dark Bootstrap 5 theme
Made using
Jul26
