Codes Required
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
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
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
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
Online Wordpress password hash generator
An online tool to generate password hash for wordpress, tried it just today ...
2020Feb13
Bootstrap3 modal Contextual colors
Bootstrap3 Contextual colors modal dialog
From
2019May19
CellCommentRead + Save
Reads/Saves a comment into a cell CellCommentRead to Reads comment from a ...
2018Jun17