Convert Numbers into English text (521 to Five hundreds twenty one), this one called (SpellNumber) I found online.
And (Num2ArText) that will do the same but in Arabic language , (as 500 to

A simple way to help Excel developers showing the progress of a long operation, what Excel lacks.
What you need to do is copy the form (Frm7) and use the module (mMain) in (XLPrgBar) file into

The first Excel functions-only calendar.
I created it as a sample for my students back in 2006 to show them how we can do monthly calendar using functions only, then I decided to share it

A formula trick to search for an item in a list and get 2nd, 3rd, 4th, 5th and 6th item occurance found.
VLOOKUP (also MATCH and HLOOKUP) only gives you the first occurance
This formula uses

Read any MySQL query into Excel table + VBA Code
This uses VBMySQLDirect application to read data from MySQL database into Excel spreadsheet
To run this you just need to install this app

Customized testing tool to test and fix MSSQL connection to DB, after playing for a while with SQL queries within Excel, it looks like we will need a small tool like this to ensure that client PC

This simple small code will watch for user input, and once user enter new name in column C, code will generate new ID (4 to 6 characters) and make sure it is not repeated, then put it in column B,

Simple macro to show how we can use multiple pictures to give the impression of on-off to end users, used in several projects before, thought I just share it here. It is basically uses two pictures

Since LEGO is a huge part of my life, I got a lot of time to spend with Bricklink.com, and if you do, you will notice that most of the time, your cart