Posts Per Year

Create summary list If you have SQL table named Table_Name, with DateAdded ...

TreeView

A plain pure VBA Treeview control to be used inside Excel (official link has ...

treeviewexcel025.zip

Listbox height changing issue

Listbox in Excel sometimes have issue adjusting height to items added inside, ...

Listbox height changing issue.zip

Scrolly

Scroll a listbox Using Right-Drag. (Something VBA in Excel lacks) You might ...

scroll_Listbox.zip

Bootstrap Modal variables

Bootstrap link to pass variables to modal content Used to build list of links ...

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

FoldersIn5

Creates list of subfolders and subfolders of each down to 5 levels Folder ...

FoldersIn

Returns list of folders found in given folder in a string in ANStr format, ...

Posts_per_Year

Gets list of years and total of posts per year from a table, by using date ...

RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

List_Load + List_Save

Loads/Saves items from/to text file to/from listbox Also has simple adding and ...

sortArray

Sort an array of Numeric values, simple straightforward Edit v3 2021-09-21: ...