Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14
Creates list of items to be used in ' Where item in (List)' list Mainly adds ...
2020Jan6
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
Dec19
Creates list of unique items found in a column, returns string with items ...
2020May6
Gets most recent N files from a given folder. Uses Arrays, and the function ...
2018Oct1
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
Show list of items with their description from "Settings" sheet Have that list ...
2018May17
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
Allow users to select from list box based on search terms. Have a text box and ...
2018Jun7
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Login screen with background, the new thing here is that the background is ...
2019Jan17
A cursor file type of Hand. used inside VBA to show hand when user hover over ...
2018Aug14
Get relative path of one to another Pass two path strings to this function and ...
2018Jul19