Codes Required
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
NumberBeforeString
Cuts a number that would be found before certain word inside a block string. ...
Feb1
ChartLabelsNumberFormat
Apply Number format of 1 decimal to datalabels of specific series in certain ...
Dec23
ANStrFind_AndOrAdd
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
Dec19
Macro keyboard shortcuts
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
PrCal_Add_Sort
Adds to daily log, two cells, one with date, next with activity that will be ...
Dec2
ForegroundColor
Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...
May5
ArrSort_4Arr
Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...
2023Apr14
UISetup + UIRestore
Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...
2022Jan28
XLShortcut_EnableDisable
Disables or Enables certain Excel built-in shortcut. Code has example on how ...
2018Aug16
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
Error_Raise
To raise a friendly error message with option to show custom error number and ...
2018Jul7
FileSize_Formatted
Returns file size in formated human way (mb, gb, etc..) Or, it can format any ...
2018Apr25
FileDate_Formatted
Returns a formatted version of file 'LastModified' date. Pass parameter ...
2018Apr25
RemoteExplorer.asp
A directory Viewer with the option of downloading the file and reading text ...
2018Apr23
ANStrList functions
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
Similar codes
Awesome Bootstrap Checkboxes
Bootstrap checkbox with font-awesome (BS-FA Checkbox)
From
2019Jul30
Magick SVGs to GIFs
Convert SVG files into GIF preserving the transparency, in bulk ' Used to ...
2019Sep5
BS Star system
Bootstrap, Font Awesome rating stars system, to replace options for users to ...
2019Sep26
Star rating system
kartik star rating system using Bootstrap and Font-Awesome
From
2019Jun23
ANBS controls
Set of functions to generate Bootstrap controls as strings. Controls available ...
2018Jun24
FontAwesome icons in Office apps
Best way to use FontAwesome set of icons in apps, mainly my Excel tools and ...
2023Jan31
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
FindAncherURL_InHTMLRow
Finds the URL (href tag value) for an anchor inside a table row (tr element) ...
Mar4
HTML_CleanNumber
Cleans block of string (HTML block) from characters that are not needed Can ...
Jan31
Pure CSS line graph
Simple, with CSS only, an HTML line graph
By
2019May9
MatchIf_ThenDelete
Searches for an item in a column, then if found, delete that cell (not clear, ...
2018Jun17