Just like other programming Languages, Excel VBA also uses different types of Variables. This Article teaches you the following Topics: 1. What is a Variable? 2. Importance of Variables in Excel Programming 3. Important Rules of Variables, you must know, before...
Results for "fun"
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...
Shortcut Keys in Microsoft Excel
Hello Friends, Here I am going to list down some useful Shortcut Keys. These keys are very useful in your day to day excel use. By making these shortcuts in practice you can do many of the things in Excel Easily. Key Description CTRL+( Unhides any hidden rows within...
Excel UDF: How to Get All words in Reverse Order from a String
I created this UDF (User defined Function) to help you in arranging all the Words of a String in Reverse Order. It will put the Words in a reverse Order. Letters of each words will remain in same (proper) order. If you want to reverse the whole String then refer this...
Excel UDF: To exctract All Numbers, Special Characters and Alphabets from a String
Sometimes you require to Extract All Numbers and Characters from a mixed String. I have written a UDF (User Defined Function) to extract them. UDF Function to Extract Numbers from a String UDF Function to Extract Special Characters from a String UDF Function to...
Format Alternate Rows using Conditional Formatting
Dear Readers, In this article I am going to explain you, how you can format the Alternate Rows of Excel using Conditional Formatting. For example, in Excel Sheet, if you want alternate rows to be shaded in different color. This you usually need when you are preparing...
Step by Step tutorial for While Loop Excel VBA
In previous Article, we had seen about For Next Loop. In this article we are going to learn about While and Do While Loop. While loop is also quite useful in Excel VBA programming. Here in this article, I will explain each and every aspect related to While loop with...
Macro to Copy from Excel in to Word Document
In Previous Article we saw how to Copy Content from a Word Document and Paste in in to the Active Workbook. Now in this Article i am going to write a function will Select a Range from Excel and paste the content in a New Word Document. Here there are two possible way...
How to compare two columns in Excel to find duplicates
Many times we require to compare two columns' data and find out all the Duplicates. So in this article, you are going to see how we can compare two columns in Excel and find out duplicates. There are two ways of comparing two columns in an Excel Worksheet. 1.By Using...
Strip HTML : How to Remove HTML tags from a String in VBA
In this article I am going to write an User Defined Function (UDF) which is used to remove all HTMLs from a String Stored in Cell. It can be used as normal Inbuilt Formulas of Excel. For writing this function i have used VBScript Regular Expression to Replace all the...
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 (=).
Download Free File Manager in Excel Macro
Hi Friends, I have created one file manager in Excel using excel macro. Basically it lists all the Files in a folder...
Excel Macro Tutorial : How to Open Excel Workbook using Excel Macro
In this article, you are going to learn How to open an Excel Workbook using VBA. Before opening an already saved Excel...
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...