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
Added: Sep, 2012 | Created: Jun
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
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
Added: Oct, 2011 | Created: May
I have seen a lot of requests asking about a lookup functionality that works for colors, this dated back in 2009 when I had some time to work on it, it is a UDF (User-defined-function) that grap the
Added: Jan, 2013 | Created: Jan
Share anything in a secure folder, Folder8 is the easy way to create a folder (secure or public) without registration. Once user creates folder, can add
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
Added: Apr, 2012 | Created: Dec
Browse files and folders inside Excel sheet, a simple tool to help you view files and folders, this was a request from one of my VBA Excel friends.
Code is visible and you can adjust it in any
This is a simple way to scroll through large area in your sheet without using Excel scroll bars
It is function-only project that enables you to brows and scroll through an area in another sheet