Shape_Select_or_CreateThenSelect

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

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

New VBS file

Add vbs to new menu in Windows Explorer. Fast way to create VBS files using reg ...

VBS-New-File.zip

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

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