Dear LEM readers, LearnExcelMacro.com is inviting you to become one of the Guest Author at learnexcelmacro.com. and get paid up to INR 1000 for each article you submit, approved and published. LearnExcelMacro.com does not compromise with the quality of the content...
Results for "write"
[YouTube Video] Complete Guide to Write your First Excel Macro
Dear Readers, Here is the second episode of the Excel Macro Tutorial for Beginners. If you have not watched the first part of the Tutorial, you can watch it here or on the YouTube Channel. Kindly provide your feedback on this video. Any improvements/ suggestions are...
VBA Beginners: How to write macro for a Command Button
Dear Beginners, Quite a few times I was getting this question from my readers - How to associate a VBA code to a button? How to write a vba code which gets executed by clicking on a command button in excel vba. Add a button to trigger my macro and so on... Here are 3...
Read and Write Document Properties of an excel Document – VBA
In this Article we will learn how to get document property of an excel workbook using Excel VBA. Before I jump in to the VBA code let's have a look Where to see document properties in Excel Document? How to see document property of an Excel document Follow the below...
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...
How to Copy content from Word using VBA
As many of us want to deal with Microsoft Word Document from Excel Macro/VBA. I am going to write few articles about Word from Excel Macro. This is the first article which opens a Word Document and read the whole content of that Word Document and put it in the Active...
Excel Macro Beginners – What is Range Object in Excel VBA
Dear readers, Before we discuss the Range Object technically, let us see what is RANGE in excel? In a very simple manner if I define Range, I can say that RANGE is a collections of cells which are in a sequence. This collection can have one or more than one cell. As I...
Excel Macro Tutorial : What is Excel Macro ?
Dear Beginner, In this Excel Macros Tutorial, you are going to learn the Basics of Excel Macro. This is the first Article of this Tutorial so Let's begin with What is Excel Macro What is Excel Macro ? Let's not get too much in detail at this point. For now, in simple...
Complete guide to Message Box in Excel VBA [FREE DOWNLOAD]
Creating a message box in Excel VBA (Visual Basic for Applications) is a useful way to interact with users and provide information or gather input. In this article, I will guide you through the process of creating a message box in Excel VBA, covering all the possible,...
5 Excel VBA Code Snippets to Improve Productivity
Introduction: Excel VBA (Visual Basic for Applications) is a powerful tool that allows you to automate tasks and enhance your productivity in Excel. With VBA, you can write custom code to perform repetitive actions, manipulate data, and create customized solutions. In...
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 (=).
VBA: Reverse a string
It is very easy to get the Reverse of a string entered by user in Excel VBA by using VBA inbuilt functionality....
Data Anonymizer: Open Source to Anonymize Personal Data
In the ever-evolving landscape of software development, safeguarding personal data is paramount. Whether you're a...
Custom Excel Formula to Count based on Color
Dear Readers, Last Friday, my wife, Shagun Sharma, who is a Vlogger shared an excel sheet with some data and a problem...