BOLDCODES

Developing library of codes, starting from my own

Fresh 16 codes

Card image
HTMLCloseTag_HasWordAfter

Finds the number of occurrence of a "Numeric" inside a string ...

Card image
CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, ...

Card image
RoundUp2

Rounds a number to nearest identifier up. Like 105 up to ...

Card image
Walking Columns (Scrollable Columns-Chart)

Allow users to scroll through columns in column-chart. Used ...

Card image
Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside ...

Card image
ANmAddressSame

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

Card image
ANmAddressRefStyle

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

Card image
ANmaFiles2List

Generating list of files in a folder. One file to do that. I ...

Card image
FixURL

Return safe URL after converting critical chars to whatever ...

Card image
RegSave, RegRead, RegDelete

Windows Registry read, save and delete branch node or key. ...

Card image
Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least ...

Card image
Get boot time

Get the last time Windows 10 was started. Needed this quickly ...

Card image
Choose20

Chooses from 20 options based on the passed ID, can have any of ...

Card image
Choose10

Choosing a return value based on an ID. Since we have Choose2, ...

Card image
CutString12

Cuts string between two numbers that found inside string. Like ...

Card image
IsNumericChar

Checks if character is number or no. Returns True or False ...

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

382 / 1,190 = 32.10%

You code?

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

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
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 ...

Card image
FixURL

Return safe URL after converting critical chars to whatever ...

Card image
Frequency

Checks how many items in an ANStr ANStr is list of items ...

Card image
Choose2

Returns a value based on an ID. If ID is 1, return 1st value, ...

Card image
Q_NoOfdays

Calculates number of days for certain quarter, starting from ...

Card image
MyDayName

Returns the day name in several formats It uses either full ...

Card image
RemoveHTML

Removes HTML code Basically all tags expected and listed below ...

Boring stats Since Feb 18th, 2018

1,190
Codes
10
Private
382
Updated
993
Tested
197
Untested
18
Programmers
714
Original
476
Imported
262.8k
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

679

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