Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

frmRename.zip

NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

Shape_Select_or_CreateThenSelect

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

SQL Related posts

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

ListBox_SelectionCount

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

Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...