Monthly Archives: December 2011

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 HTML tags with BLANK "". In code you can see [...]

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. In other words you can call it as Cell Address. This Cell [...]

By |Categories: Excel Formula|Tags: , |1 Comment

Excel Macro Tutorial : VBA Spin Button

In the previous Article How to write Excel Macro - Your First Excel Macro of Excel Macro Tutorial, you have seen how to write Excel Macro. Also in Previous Tutorials, you have seen all the basic concept of Excel Macro. In this Article I am going to show you how to Add and Use Spin Button. Spin Button: Spin button [...]

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 are going to learn how to send an email [...]

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 some times you may need to send some Details or Result directly to your email ID or any other ID using Excel Macro. If you have some report or details which you want to send [...]

How to Disable Right Click in Excel Workbook

Some times for some security reason or some other reason, you want to disable right click on the Workbook or Worksheet or on a particular Cell or Cell Range. 1. Disable Right Click on Whole Workbook 2. Disable Right Click on whole WorkSheet 3. Disable Right Click on a Cell or Cell Range 1. Disable Right Click on Whole Workbook [...]

COUNT and COUNTA Function

COUNT(): COUNT is a Excel inbuilt formula. It takes CELL RANGE as an input and give the total count of the Cells which are having Numeric Values. Important: COUNT counts only those cells which are having "Numeric" Values. It ignores those cell which are having non-numeric values. Syntax: =COUNT(Cell Range) Input Parameter: Cell or Cell Range ("A1:B2") or ("A1") Output: [...]

By |Categories: Excel Functions|0 Comments

How to Extract Email ID from a String in Cell

If you want to extract email ID from a String Stored in any cell, it is possible by writing a Simple UDF (User Defined Function) in Excel. After writing this UDF, you can use this function as a normal Excel Function. Follow the below Steps: 1. Open Visual Basic Editor (Alt+ F11) 2. Open an Existing Module or add a [...]

Auto Open Macro / Auto Run Macro

Sometimes in Excel Macro, you need to execute a Macro / Piece of code as soon as you open the Workbook. By Doing this no need to trigger that Macro or functions just by opening that workbook. There are two methods to achieve this. Method 1: Auto Run Macro in VBA Module of the Excel: Follow the below steps: 1.Open [...]

ADO RecordCount Property – RecordSet Object

The RecordCount property returns a long value that indicates the number of records in a Recordset object. Many a times you might have observed that RecordCount Property does not return a correct number instead it always returns a number -1. RecordCount Property returns -1 because by default the Cursor is adOpenForwardOnly. To get the exact Record Count from your RecordSet [...]