It's been a long time since I posted an article :(. Today I am going to write about Combo Box in Excel. At the end of this Article, you will be able to use Drop down in Excel. It will include 1. Adding Items in Excel Combobox dor Excel Drop Down 2. Removing...
Results for "while"
Progress Bar in Excel VBA
How to use Progress Bar in excel Macro (VBA) Progress bar is nothing but a placeholder, where you see the Progress of the operation which is getting performed. Like Visual Studio there is NO already built progress bar in Excel Macro (VBA), which you can use it as an...
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...
How to format whole row or a Range by Conditional Formating
Sometimes in Excel, we need auto-formatting as soon as a condition in a particular cell or cell range is satisfied then the formatting of the whole row or a cell range should change. This is very easy to do in Excel by using Conditional Formatting. Let's take an...
Excel Macro Tutorial : For Next Loop in Excel Macro
[fullwidth background_color="" background_image="" background_parallax="none" enable_mobile="no" parallax_speed="0.3" background_repeat="no-repeat" background_position="left top" video_url="" video_aspect_ratio="16:9" video_webm="" video_mp4="" video_ogv=""...
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...
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...
References In Excel Formulas – Absolute and Relative
This article is not about Excel Macro but this is about Absolute and Relative References in Excel formula. In Excel Formulas, as you have seen, for referring any cell, we use the Address (Reference) of that Cell like A1, B2 etc. This is called Cell Reference in Excel....
How to send email from Excel Macro from Outlook
This is continuation of my Previous Article you learnt How to Send Email From Excel VBA, using Gmail and Yahoo Email Account. In my Previous Article, How to send email from Excel Macro, as you saw how to send email by Excel VBA from Gmail or Yahoo In this article you...
How to Send an Email using Excel Macro from Gmail or Yahoo
Dear Readers, In this article, we are going to learn how to send an email automatically by Excel Excel VBA. While executing the Excel Macro, sometimes you may need to send some Details or Results directly to your email ID or any other ID using Excel Macro. If you have...
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 Add-in – File Manager
Dear LEM Readers, It's been long time since I wrote any article here. I was really busy in some personal work...
HP Quality Center – Create Folder Structure in Test Lab and Pull test Cases from Test Plan
Dear LEM Readers, In previous article, we learnt How to connect to HP QC using Excel Macro. In this article, we are...
How to insert a picture in excel using VBA
Dear Friends, In this article, I am going to teach you a simple VBA code, which help you in inserting a picture in...