Hello friends, I have created a Youtube channel where I am going to share many more recorded video tutorials for beginners, intermediate and advanced users. Don't want to miss any of the videos? Then Subscribe to my Youtube Channel. Subscribe my channel on Youtube Do...
Results for "record"
Invoice Template [ FREE Download ]
Hello friends, There are many small businesses which are using Excel for their day-to-day management. Like Generating invoice, quotation, tracking data about customers, sales, employees etc. In nutshell complete management is done in excel spreadsheets. I manage my...
Spreading an Array values across Columns in Excel – VBA
All my avid readers from Computer Programming backgrounds must be thinking is it a big deal? Like other programming languages use loop to traverse all the values of an array and spread them across rows or column. Right? If you are thinking so... you are...
How to assign a Shortcut key to a Procedure or Subroutine
Dear LEM (Learn Exel Macro) Readers, It's been long time I wrote any article or answered any of your queries. Apologies for the delay in response. I am back with many more amazing articles now. All your un-answered questions will be answered in few days with a set of...
Download : Excel Macro Application to Send Multiple Emails – 2.0
Hello Friends, I got many good response on the tool - Send Multiple Email Workbook. I also got a request to implement much other functionality as well. The attachment was one of them. In this version, I have added the attachment functionality with some other small...
Download : Excel Macro Application to Send Multiple Emails
Hello Friends, I was getting queries on : How to send Email from Excel ? How to send Email from Gmail in Excel Macro ? How to Send Email from Yahoo in Excel Macro ? How to send email from Outlook in Excel Macro ? How to send Multiple emails using Excel Macro ? Keeping...
Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding)
Let's take a brief recap of all things you have studied so far in Excel Macro Tutorial. So far you have learnt so many basic stuffs about Excel Macros under Excel Macro Tutorials. You have learned about all the Controls available in Excel Macros and also how to use...
Excel Macro Tutorial : Excel Form
In this article, I am going to explain every aspect of the VBA Form. User forms in Excel are really nice to see. It looks very fascinating while working with User Forms. You can build a very nice UI (User Interface) using Excel VBA Form. In this article, you are going...
Assigning Macro : How to assign macro to Hyperlink ?
So far we have always seen running any Macro or Function using a Command Button. Sometimes, instead of putting a Command Button, you want to do the same operations but by using a Hyperlink in Excel. In this article, you are going to learn how to run a macro by using...
Excel Macro Tutorial : How to write Excel Macro – Your First Excel Macro
Dear Readers, Till now we have learnt following things in Excel Macro Tutorial . In this part of Tutorial you are going to learn how to open the VBE Code Window in Visual Basic Editor of your Workbook and start writing your first macro. 1. What is Excel...
Buy a coffee for the author
Download FREE Tools and Templates
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
Distance Calculator in Excel VBA [REVISED]
Hi guys, on June 2016, google made some changesaround pricing and authentication etc. of its FREE APIs.Distance...
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...
40 Useful Excel Macro [VBA] examples – Part 2 of 2 [ FREE DOWNLOAD ]
Dear friends, As you see this is the second and last part of the tutorial 40 Useful Excel Macro [VBA] examples. In a...