Codes recently modified Codes modified recently by our developers. 15 most recent codes.
Shape_Select_or_CreateThenSelect v2
Selects a shape inside sheet to change it, or if not found, it will create it ...
WP Logout link v3
I have been playing with WordPress recently, and of course faced some ...
Convert2SQLDate v3
Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...
FixPath, IsThere, IsThere1 ... v9
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
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 ...
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 ...