Codes Required
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
MatchIfUp or MatchIfRev
Searching for an item in a column from bottom to top. Will search for item in ...
Apr8
ContainerHTMLTag_ReturnBlock
Returns the full string starting from open tag of container where LocationIndex ...
Apr3
Between2int and Between2intinc
Checks if number between two numbers, with or without considering those numbers. ...
Mar23
NumberNumberNumber
Finds 3 numbers in a string by ignoring characters between them. ' example ...
Mar2
HTML_InsideTag_ByIndex
Checks if LocIndex is found between open and close of HTMLTag or between close ...
Feb28
CutString_ReverseFrom
Returns full string starting from the point of LocIndex minus back where we ...
Feb27
ReNumber_IDColumn_inTable
Reset numbers in ID column, with help from AI. The StoredProcedure will move ...
Dec17
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
NameSilo_APICall_ListPrices
Downloads list of domains and prices for register, renew or transfer into ...
2018May25
ANStrList functions
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
DB_SettingRead + DB_SettingSave + ...
Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...
2018Apr14
Similar codes
ListBox_SelectionCount
Counts how many items selected in a listbox (multi-selection listbox). Works ...
2022Apr21
ListBox bug with TabIndex
Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...
Apr15
setSelectedIndex byname and byval
Set active (Selected) item in listbox using javascript Imported and modified ...
2021Jun10
Bootstrap Tags input
Tags input (Tagsbox) in bootstrap
From
2019Jul1
Bootstrap Select
Multi-select drop-down in Bootstrap with customization
From
2019Sep16
Excel sheet textbox
Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...
2020Feb22
Random GUID
Generate a random GUID using oracle db workbench Also add timestamp to ensure ...
2019Dec22
MoveDown + MoveUp
Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...
2018Jun2
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
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
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
ChartLegendCenter
Put chart legend at center of chart horizontally. Changes left and width only. ...
Dec21
NumberFoundinsideTag
Checks if a number found between two characters, searching can be customized to ...
Aug21
Featherlight.js
A nice and new lightbox, modal, or whatever you call it (version 1.7.13) From ...
2019Jun26
Control the Panel
A set of commands (or shortcuts) allowing users to access Control panel items ...
2019May19