ANBS controls

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

FGColor_Calc

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

RunFromTemp

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

GetColumnName, ColumnName_XOffset

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

Convert2SQLDate

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

Crypt128

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

OpenPassword + ClosePassword

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

GenerateMemorablePassword

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

FrmAbout

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

FrmAbout.zip

FindSheet

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

Crypt512

To encrypt or decrypt any string ' Strii is the required text to protect ' ...

StringFlip

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