Search results 136

Sorted from new to old.

CreateAnchor

Creates an anchor by passing its arguments (used to be called URL2A), can ...

2018Jul17

ExcelMenu_onfly

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

2018Jul17

SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9

IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

2018Jul7

Error_Raise

To raise a friendly error message with option to show custom error number and ...

2018Jul7

ServerVar

Get value of Server variable by passing variable name aVar can be any of these ...

2018Jul4

ANBS controls

Set of functions to generate Bootstrap controls as strings. Controls available ...

2018Jun24

FGColor_Calc

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

2018Jun20

RunFromTemp

Check if an Excel file is running from 'Temp' location or regular folder This ...

2018Jun17

GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15

Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

2018Jun14

Crypt128

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

2018Jun14

OpenPassword + ClosePassword

Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...

2018Jun14

GenerateMemorablePassword

Returns a random password that is easier to remember, such as BONES or LAMOT. ...

2018Jun11

FrmAbout

Display a string in a Userform as 'About' window, can display string or file by ...

2018Jun11

FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

1 2 ...8 9