Codes Required
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
PivotTable_ShowHideItems
Show or hide item (or items) in PivotTable for a certain field. Passing ...
Jan23
PivotTable_ShowHideBlankItems
Shows or hides an item or items in a PivotTable filter field. Passing ...
Jan22
Macro keyboard shortcuts
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
AddDatabar_ConditionalFormatting
Adds databars conditional formatting to range of cells. Passing column, start ...
2022Aug22
Shape_Select_or_CreateThenSelect
Selects a shape inside sheet to change it, or if not found, it will create it ...
2022Jul21
ListBox_SelectionCount
Counts how many items selected in a listbox (multi-selection listbox). Works ...
2022Apr21
DynamicFill
Fills in more rows at end of a range Used to add more rows at end to have all ...
2022Mar11
UnMergeFill
Unmerges all merged cells and duplicate cell contents into them. In another ...
2019Apr16
ConvertMultiLine2 + 6
Convert text blocks (by converting line separators from any separator to any). ...
2018Jul11
Limit Textarea
Show number of characters in a textarea and limit if it goes greater than ...
2018Jul5
ANBS controls
Set of functions to generate Bootstrap controls as strings. Controls available ...
2018Jun24
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
ANStrList functions
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
Similar codes
ImagesIn_Count
Counts number of image files found in a folder Images defined here are files ...
2018Nov25
BrowseImage
Asks user to select an image and returns full path and name of selected image ...
2020Dec19
ShapeRange_BG
Replaces the background fill of any shape in Excel with an image Not Ready yet, ...
2021Mar27
ImgDimensions
Reads image dimensions, width, height, depth and image type. Details returned ...
Jan16
LoadPicture_Safe
Loads an image into VBA image control without knowing its extension If file ...
2018Jul7
IsThere1_Image
Searches for an image and return the file extension of found, or returns null ...
2019Dec7
Files_MostRecentN
Gets most recent N files from a given folder. Uses Arrays, and the function ...
2018Oct1
Barcode Generator
Pure ASP Classic barcode generator This is one of my past findings, I will be ...
2020Feb1
ImagesIn_User
Gets images in a folder where filenames start with "User" Similar to function ...
2019Dec31
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
InStr and InStrRev
How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...
2021Dec6
Simple Captcha
Sometimes the simplest methods is the most powerful.
That is what I said
2018Dec27