Codes recently modified Codes modified recently by our developers. 15 most recent codes.

Card image cap
Frm9 - Select workbook (or workbook/worksheet) v3

Gives your user ability to select a workbook from list of open workbooks within ...

Card image cap
Progress in two nested loops v2

Formula to show progress to end user from inside two loops. More like an ...

Card image cap
UnixDateTimeNumber v2

Calculates Unix date/time number of a given date/time. Needed it to pass ...

Card image cap
Antispam - Hiding textbox v2

Anti spam email web form idea.

Card image cap
Popup button v2

List of commands in popup menu. Uses listbox, command button and toggle ...

Card image cap
Shape_Select_or_CreateThenSelect v2

Selects a shape inside sheet to change it, or if not found, it will create it ...

Card image cap
WP Logout link v3

I have been playing with WordPress recently, and of course faced some ...

Card image cap
Convert2SQLDate v3

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

Card image cap
FixPath, IsThere, IsThere1 ... v9

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

Card image cap
VBInstr (or Instr parameters) v3

The great function InStr I use a lot has a small confusing part. Which string ...

Card image cap
ListBox_SelectedIndexes v3

Create list of selected items in MSForms listbox as string separated by | Or ...

Card image cap
ListBox_SelectionCount v2

Counts how many items selected in a listbox (multi-selection listbox). Works ...

Card image cap
DateDiff_En v2

Calculates the differences of date (against NOW) and return in English ...

Card image cap
Magick SVGs to GIFs v5

Convert SVG files into GIF preserving the transparency, in bulk ' Used to ...

Card image cap
Excel-VBA Limits v3

These are some limits I found during my work in Excel-VBA For more of Excel ...