Codes Required
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
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
CopyFiles Excel-Macro
Simple macro to make sure we have a copy of all files in a folder found in ...
Mar12
Just learnt that now
Looks like we cannot have filename (having no extension) and folder in same ...
Mar5
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
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
Similar codes
Files_MostRecentN
Gets most recent N files from a given folder. Uses Arrays, and the function ...
2018Oct1
ImagesIn_Count
Counts number of image files found in a folder Images defined here are files ...
2018Nov25
strUnQuote
This will tests to see if strQuotedString is wrapped in quotation marks, and, ...
2018Jul3
GetColumnName, ColumnName_XOffset
Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...
2018Jun15
Remove_Between2Quotes
Remove any char (or string) found between two quotes in a string This is an ...
2020Mar9
HTMLTag + HTMLPair
Generate HTML tags with thier parameters as name=value pairs ' Example of ...
2018Jun30
Container Switcher
Using Classic ASP and cookies, allow users to personally choose between normal ...
2018Jun10
VBA Progressbar (Frm73)
Progress bar Frm73 or just simple message Zip file contains .frm and .frx ...
2018May16
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
Random Codes
Excel sheet textbox
Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...
2020Feb22
Win10 User Folders
I hate it when Microsoft takes back some controls it already gave to users, one ...
2018Jul9