vishwamitra

About Vishwamitra Mishra

My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor’s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.
Thanks for visiting my blog.

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 [...]

How to connect to Access Database – ADO Connection String

Using Excel Macros (VBA) you can connect to any Databases like SQL, Oracle or Access DB. In this Article you will learn, how you can do a connection with an Access Database. Access Database connection string is different for Access 2003 (*.mdb) and Access 2007/2010 (*.accdb) because Drivers are different for both the databases. For Access 2003 Database the Provider [...]

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 Macro ? 2. How to Record Macro / How to [...]