Monthly Archives: September 2018

UDF to Convert Numbers to Letters

First of all, wouldn't it be great if we have a built in function in Microsoft Excel to Convert Numbers to Letters. It means, simply, by using a formula in excel, I could Spell Numbers in Words. In banking or accountancy, this is used to write grand total amounts. Amounts are mentioned in Numbers as well as words. You probably [...]

Early Binding v/s Late Binding in Excel VBA Programming

Early and Late Binding is a common phenomena across computer programming languages. In simple terms, Binding means - how and when methods or properties of an Object are compiled and checked. In case of Excel VBA [COM - Component Object Model] - this occurs when you are trying to automate something which is not part of default object library of [...]

Regular Expression and its usage in Excel VBA

Dear Reders, In this article, I am going to teach you What is Regular Expression (RegExp or RegEx)? and how RegEx is used in Excel VBA programming. You will also learn usage of Regular Expressions in Excel VBA with some example VBA code. You can also find some simple regular expression patterns which are more often used. Refer the following [...]

By |Categories: Excel Functions, Excel Macro, Excel Tips|Tags: , , |Comments Off on Regular Expression and its usage in Excel VBA