COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

fNMRPrgs, Full-form progress bar (frm77)

Show progress bar inside userform, with option to control lots of things. This ...

Frm77.zip

tag_add

Add to textbox from listbox (select option) ensure its uniqueness

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

Frm81 - FullDetails

Show window of details, can be used to show content for certain cell, or show ...

Frm81.zip

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

Frm6.zip

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

Bootstra/386

A bootstrap v2, v3 or v4 theme to make webpages look like they are from the ...

BOOTSTRA.386-master.zip

CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

JSON-VBA.zip

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...