Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

AskForFolder

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

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

Shape_Select_or_CreateThenSelect

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

iframeBtn

A button in iframe, to run certain command and return status to end user ...

iFrameBtn.zip

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...