BOLD.CODES

Online library for BOLD coders by BALD coders

Fresh 16 codes

Card image
ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Card image
VBInstr_Any

Returns the index where any of the words from AnStrSearchFor ...

Card image
ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

Card image
VBInstr_Any

Search for string inside another, with ability to have multiple ...

Card image
ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another ...

Card image
Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to ...

Card image
ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on ...

Card image
ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a ...

Card image
RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). ...

Card image
ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call ...

Card image
Showing 4k (and more) images in BS5 modal

Allow users to browse and scroll through tons of images to ...

Card image
SSL/TLS certificate add/update

Always found myself struggling when applying security to ...

Card image
Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the ...

Card image
SettingRead_Bulk

Reads list of passed SettingNames with defined separator from ...

Card image
Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column ...

Card image
Match4_4thNot0

Searches for three cells in three columns then checks for 4th ...

Boldfresh indicator

How fresh is code in this website? A calculation of total number of codes with version higher than 1 divided by total codes. An indicator showing how serious we are about the "Developing" aspect of writing code.

Bar Chart

387 / 1,212 = 31.93%

You code?

Join our growing community of programmers.
Add your dev work here, just login into your Linkedin account and accept Bold.Codes!!

We log you in with your Linkedin, we save no passwords, no new password to remember, no new login, first time you in, we just save your name and ID issued to you by Linkedin.

Linkedin Login

Code share made easy

Programming functions and subroutines (or snippets, codes, etc.) that each can be downloaded separately or combined as a module.

This website is result of my efforts in categorizing and organizing my library of programming codes during my work years. A practice I managed to maintain since 1997, it helped me a lot in advancing in creating customizable and upgradable tools quickly and easily.

Programs website (Programs.ws) Sister website

When you code for a long time like me, you use tools, lots of them, and knowing myself, I have to keep them in a list. This is the list Programs.ws.

These tools are either webtools, applications in Windows or Android systems.

Featured Codes
Card image
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These ...

Card image
WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and ...

Card image
GetAmazonPrice

Reading price of an item in Amazon. An AI-generated function ...

Card image
iframeBtn

A button in iframe, to run certain command and return status to ...

Card image
Fill down

Fill down series in Excel. NotReadyYet! This is a ...

Card image
A is for Alpha

Military way to communicate letters in audio, for me I learned ...

Card image
Special chars

How to type special characters in keyboard using ALT + keypad ...

Card image
Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for ...

Card image
FeeKey + UnFeeKey

Protect Numbers by encoding them into Alphabetic And convert ...

Card image
CountDuplicates

Counts how many duplicates found in a range of Excel cells. ...

Recently updated
Card image
Match4_4thNot0

Searches for three cells in three columns then checks for 4th ...

Card image
Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column ...

Card image
ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. ...

Card image
FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current ...

Card image
BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with ...

Card image
MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just ...

Card image
ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells ...

Card image
ANmAddressSame

Checks if passed addresses are referring to same cell regardless ...

Boring stats Since Feb 18th, 2018

1,212
Codes
10
Private
387
Updated
1,014
Tested
198
Untested
18
Programmers
736
Original
476
Imported
262.9k
Views
91.5k
Downloads
18
Programming languages
14
Categories

Excel functions (XLFxs.com) Sister website

XLFxs.com have Excel formulas, function combinations and other tricks and tips in Microsoft Excel to achieve several tasks and make life easier!

If codes here are little bit overwhelming, you can use Excel functions (and some other tricks) to do certain tricks to some level!

Our Programmers Top 3 programmers

701

ANmarAmdeen

26

JeffSmith

4

DevinGarlit

Top 5 Categories

Components

Controls, objects and classes, also cells, sheets, workbooks in VBA-Excel

UI

User interface, user controls, and display codes

Texts + Strings

Texts, strings, convert, replace, encode, parts and concatenations

File System

File structure, folder, FTPs, local, intranet and a like

Sessions

Codes for sessions and temporary memory managements.

All Categories

Top 5 Languages

VBA-Excel

Visual basic for applications that works only in Microsoft Excel, aka macros

ASP Classic

Active Server Pages for web development. Code here can also be used in VBA, VBA-Excel or VB6

JS+JQuery

Java script, JQuery that enhances web apps

VBA

Visual Basic for Application (or macros) in most applications. Code here can also be used in VBA-Excel

HTML+CSS

HTML scripts along with CSS styles

All Languages