Here is the UDF to Convert Numbers to Words in Hindi Language. This can be extended for other Languages as well with little modifications, do let me know your thoughts in comments. How to create the function Called SpellNumber() 1) Start Microsoft Excel. 2) Press ALT+F11 to start the Visual Basic Editor. 3) On the […]
Articles Tagged: VBA Macros
How to VLOOKUP to get Cell Color and Font Color along with Lookup Value
VLOOKUP is my first love of Excel, it is great function to get the corresponding values from a table easily, however there is situation where we might want to get the cell color and font color along with lookup value. VLOOKUP is a function which will return only values, but not the cell formats. Thankfully Excel allows […]
How to Show Full Path in Excel Title Bar?
Problem Statement: Is there a way to display complete path of the document and not just the file name in the Excel title bar ? e.g. I would like to see C:\MyExcelFiles\MonthlyBudget.xlsx in Excel title bar instead of just MonthlyBudget.xlsx In Excel, there is no setting/straight way for us to display the full path in […]
Excel VBA: Different Types Of Excel Macros
Excel support services will receive scores of different questions each and every day. The range of the questions definitely covers a lot of ground. Among the most common of questions asked is “What are the different types of Excel Macros?” This is a helpful question to ask because if you do not know the different […]
Excel VBA Tip: Remove Blank Lines From A Text File with Condition
If you’ve ever worked with text files, you’ll know how frustrating it can be to remove empty lines. Part of the problem is that you don’t want to remove every blank line otherwise it might upset the formatting of the document. This article will show you how to remove a set number of blank lines […]
How to Automate MS Excel Using Visual Studio.NET
Introduction I have written this article to address requests I have been getting through e-mail on how to automate MS Excel. Most people who are looking at this article might also be interested at the following articles for automating MS Word documents. Here is the link for Automating MS Word using C#, and here is […]
VBA Tip: Filter An Excel Table On Multiple Columns
Filtering information out of a larger data set is standard Excel functionality but sometimes it’s necessary to fine tune the filtering to get the information you need. For example, you might have a list of customers prioritized as A,B or C. Additionally, you could have them listed by region. Something like this. Customer, Category, Country […]
Excel VBA Tutorial : Workbook Events and Procedures
Today we will learn about Workbook Events and Procedures Workbook Activate Event This event will run code whenever this specific workbook is activated. Workbook AddinInstall Event This event will run when the specific workbook is installed as Add-In in Excel. Workbook AddinUninstall Event This event will run when this workbook is uninstalled from Excel’s Add-Ins. […]
How to Download/Extract Product Details from eBay Shopping Website in Excel
Excel VBA Solution to Download/Extract Product Details from eBay Shopping Website.
Many businesses use Ebay to sell surplus inventory and many individuals and small businesses use Ebay as a marketplace to make a profit. Unfortunately, the data cannot be download into an excel readable format or pasted into excel for obtaining statistics and do some analysis. This application accesses Ebay data and populates on Excel worksheet with it. It has a simple interface to allow the user to input the ebay url for the product or results that he or she wants to download.
How to extract initials from names in Excel?
Here I introduce few tricks to quickly extract initials from the name list in Excel, like TCS for Tata Consultancy Service and JFK for John F Kennedy. Check in here to learn how to do it.