Monthly Archives: October 2012

Important : Declaring multiple Variables with one Dim Statement

Hello friends,   As you know in VBA variables are declared using Dim Statement. You have also learnt about how to declare a variable in VBA in the previous articles. You have also learnt about Implicit and explicit option variables.   Here is a question: In below image there are two ways of declaring three variables VAR1, VAR2 and VAR3 [...]

VBA Programming : Decision – Select Case

Hello friends in the last article of VBA Programming Tutorial you have learnt the use of If..else statement. In this lesson you are going to learn another decision making statements in VBA. It means it is another way to control the flow of program, that is nothing but Select... Case structure.   Syntax:   Select Case <test_expression>     Case <condition_1>       <Your code [...]

Implicit and Explicit declaration of variables in VBA

Hello friends,   In the Article related to variables in VBA, I had explained following things: 1. What is Variable ? 2. Importance of Variable in Excel Programming 3. Important Rules of Variables, you must know, before declaring a Variable 4. Different Types of Variables 5. How to Declare / Initialize and Assign value to a variable 5. Scope and [...]

How to insert Outlook Signature in Email by Excel VBA

In this Article you are going to learn how to insert Outlook Signature in outlook email while sending an email via Excel VBA. It means while sending an email from Outlook via Excel Macro, if you want already saved signature to be inserted at the end of your email, then here is the code to do so.  

By |Categories: Excel Macro|Tags: , , |13 Comments