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...
Hello friends, In this article, I am going to explain you, how can you use special characters in Excel VBA and formulas without breaking the syntax. For Example: You can not use double quote or any other Special Characters, which are generally a part of Formula...
Dear Friends, Its been a while I posted any post here. I am back with so many interesting stuff for you in Excel VBA. Here is a very small but useful excel vba tip for you. This is about knowing the range which are currently visible to the user on his/her screen. Do...
To wish you and your family a very Happy Holidays and Merry Christmas, I have prepared an Animated Christmas tree lights with snow man, snow flakes etc. in excel sheet with the help of simple bubble graphs, formulas and a simple VBA code to Start and Stop the...
Dear Friends, Providing proper short descriptions for each of your functions or statements etc. makes your VBA code - easy to read, easy to understand by anyone who refers your code. Now the question is, how can you write description in English language in between...
Dear All, In Tutorial section for Beginners, I have written many basic articles like WHAT IS EXCEL MACRO, HOW TO WRITE IT, WHERE TO WRITE IT etc. As you know Errors are common while writing your code in VBA or in any other programming language for that matter. This is...
This is a continuation of my previous article about Interaction with Power point Slides using Excel Macro. In my previous article we learn how to create a New Power Point Presentation using Excel Macro (by creating Power Point Object). Bit of a Story about this...
Dear Readers, LearnExcelMacro.com is going to conduct a FREE online session on "Basics of Excel VBA". This session is going to be conducted on Google-Hangout hence to receive an invite for this FREE session you need to register yourself by submitting the below...
Wishing you a very Happy Diwali to you and your family. May this Diwali brings health, wealth and prosperity in your life. May this festival of Lights brings light in each one of your life For my readers who does not know about this festival: This an Indian Festival...
[fusion_text] ear Friends, First of all, I apologize for not responding to many of your questions around dealing with PowerPoint presentations through Excel Macro. Many of you have sent me so...
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.
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 (=).
In the first part of this article, I am going to share very small but useful VBA codes which are most frequently used...
In Excel VBA you can assign a hot key for a command Button as well. It means you can assign a hot key to a command...
Dear LEM Readers, In the previous article, you learnt how to assign or modify a shortcut key using excel...
