Codes recently modified Codes modified recently by our developers. 15 most recent codes.
VBInstr (or Instr parameters) v3
The great function InStr I use a lot has a small confusing part. Which string ...
ListBox_SelectedIndexes v3
Create list of selected items in MSForms listbox as string separated by | Or ...
ListBox_SelectionCount v2
Counts how many items selected in a listbox (multi-selection listbox). Works ...
DateDiff_En v2
Calculates the differences of date (against NOW) and return in English ...
Magick SVGs to GIFs v5
Convert SVG files into GIF preserving the transparency, in bulk ' Used to ...
FixPath, IsThere, IsThere1, GetPapa, GetSon v8
Set of 5 functions to deal with filesystem. Gets current workbook path, ...
Excel-VBA Limits v3
These are some limits I found during my work in Excel-VBA For more of Excel ...
Listbox height changing issue v2
Listbox in Excel sometimes have issue adjusting height to items added inside, ...
Special chars v5
How to type special characters in keyboard using ALT + keypad numbers I also ...
InStr and InStrRev v2
How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...
A is for Alpha v2
Military way to communicate letters in audio, for me I learned not all required, ...
Parts-File2Page v6
A classic ASP include file to read txt file of list into a page using bootstrap ...
ArrSort_2Arr v2
Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...
ANmaVBATemplate v3
Template to be used for any new tools, having... D sheet, WelcomeSheet, code ...
merge2Arrays v2
Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...