Codes recently modified Codes modified recently by our developers. 15 most recent codes.
Frm9 - Select workbook (or workbook/worksheet) v3
Gives your user ability to select a workbook from list of open workbooks within ...
Progress in two nested loops v2
Formula to show progress to end user from inside two loops. More like an ...
UnixDateTimeNumber v2
Calculates Unix date/time number of a given date/time. Needed it to pass ...
Antispam - Hiding textbox v2
Anti spam email web form idea.
Popup button v2
List of commands in popup menu. Uses listbox, command button and toggle ...
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 ...