Protect VBA

Protect VBA project from inside VBA This is the raw way, there has to be other ...

This Year

A quick JS way to get the year of today, a method found it online, and wanted ...

SQL Join

Different types of join in SQL. A good illustration image i found during my ...

Scrolly

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

scroll_Listbox.zip

ImageRotate_IrfanView

Rotates an image using irfanview (i_view32.exe attached) Rotated image can be ...

Resources.zip

ExcelMenu_onfly

Creates Excel menu on the fly, list of menu items, command actions, and icons ...

Weighted_Average

Does a weighted average, knowing that mathematical average between two numbers ...

Capitalize

This function capitalizes first letter of each of the words in a sentence, ...

FGColor_Calc

To set the color of the foreground based on background color to get best look. ...

GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

StringFlip

Flips a string, right-to-left, and if passed again, will flip it back Can be ...

CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...