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
HTML_InsideTag_ByIndex
Checks if LocIndex is found between open and close of HTMLTag or between close ...
Feb28
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
UserChanged_Log4
Adds date to column1 when user enters text in column2. Also, if user remove ...
Nov28
ReplaceChars
Replaces all chars found in Chars_to_remove from String1 with Char_to_put One ...
2018May26
NameSilo_APICall_ListPrices
Downloads list of domains and prices for register, renew or transfer into ...
2018May25
DownloadFile
Download a file from URL from inside Excel into certain path, returns blank if ...
2018May22
FrmLarge v3
Shows an image after clicking on its thumbnail, like in web applications Can ...
2018May20
Calendar, a pure-VBA userform (FrmCal)
VBA pure Calendar form, no outside lib needed Edit 2020-03-18: Enhance ...
2018May16
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
DB Functions (By AI)
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
Subtotal_Indirects
Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...
2021Nov26
Quarter_to_Words
Convert Quarter code to text per special project requirements. A special ...
2020Dec17
Online Wordpress password hash generator
An online tool to generate password hash for wordpress, tried it just today ...
2020Feb13
Arabic in MySQL
Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...
2023Apr12
CreateThumbSquare_IrfanView
Creates square thumb for an image, regardless of image aspect ratio It will ...
Jan18
WorkbookSave_ANmar
Saves a workbook handling several scenarios and decide what to do based on each. ...
Aug9
HTMLTagAttributeValue
Reads value of certain tag attribute from certain attribute Identify attribute ...
2021May30
Lined Paper in CSS
Lined paper CSS
From
2019Sep5
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
ConcatenateStrings_AmongString
Collect strings matching search from a longer string. I used it to concatenate ...
Jan17
A is for Alpha
Military way to communicate letters in audio, for me I learned not all required, ...
2021Dec6
Permission Denied error
Issue: Trying to copy file (Using VB command FileCopy) while that file was ...
2018Sep26