How to write VBA code (Macros) in Excel? To write VBA code in Excel open up the VBA Editor (ALT + F11). Type 'Sub HelloWorld', Press Enter, and you've created a Macro! OR Copy and paste one of the procedures listed on this page into the code window. What is Excel VBA? VBA is the programming language used to automate Excel. VBA Code Excel Macro Examples – Useful Macros, Codes, 100+ How To explained for Basic Beginners to Advanced VBA users. Tutorials to learn Excel 2003, 2007, 2010, 2013 Macros and Mastering in VBA. Selected examples to deal with different objects, methods and properties in Excel. Visual Basic for Applications (VBA) is the simple programming language used within Excel to develop macros and complex programs. VBA is functionally rich and extremely flexible. Calculating Net Present Value (NPV) Calculating Internal Rate of Return (IRR) Excel VBA Code Samples. Enable Macros in Excel; Range Object in VBA. How to write a visual basic program. Visual Basic programs for beginners with examples. How to print a string in visual basic. Below are some examples of visual basic programs. In this tutorial, Will see some basic string operation like how to print string and char in visual basic. Check the visual basic program for mathematical operations.

How to write a visual basic program. Visual Basic programs for beginners with examples. How to print a string in visual basic. below are some examples of visual basic programs.

In this tutorial, Will see some basic string operation like how to print string and char in visual basic. Check thevisual basic program for mathematical operations.

Let’s start with the basic “Hello World” Project in Visual basic. Start any programming language with some string operation is a really good idea.

Write a visual basic program to print a string “Hello World”

The below code will print the string value “Hello World”. Console.WriteLine(” “) is used to print any value as an output and the Console.ReadLine() is used to read the next line here we are using it to hold the screen.

Output: Hello World

Visual basic program to print a string variable.

Declare a variable in visual basic is really simple. here in the below code. Dim str As String is a variable decoration. Where str is a variable of string type.

Output: Write First Program in Visual basic

How to Concat two string in Visual basic.

+ or the & operator is used to Concat two or more string in Visual basic. Below is the code to Concat two string in visual basic. Which contains 3 strings str1, str2,str3.

Output: Visual basic program

Please check more examples on visual basic program for beginner

Visual Basic programs with example

Basic Vb programs

Example 2.1.1

Example 2.1.2

You can also use the + or the & operator to join two or more texts (string) together like in example 2.1.4 (a) and (b)

Example 2.1.4(a)

Private Sub

A = “Tom”
B = “likes”
C = “to”
D = “eat”
E = “burger”
Print A + B + C + D + E

End Sub

Example 2.1.4(b)

Private Sub

A = “Tom”
B = “likes”
C = “to”
D = “eat”
E = “burger”
Print A & B & C & D & E

End Sub

Visual Basic Code Examples For Excel

Write a VB program to convert Celsius to Fahrenheit

Java Program for Interview with example

Past Year’s Placement papers for Interview of MNC

What are Macros?

They are a series of commands used to automate a repeated task. This can be run whenever the task must be performed.

How to access Macros

Click on the ‘View’ tab, at the end you’ll find the function ‘Macros’ arranged in the Macros group. Click the arrow under ‘Macros’ where you can manage your macro performances easily.

To edit a macro, click on the ‘Edit’ button, this will take you to the ‘Visual Basic Editor’ where you can easily modify the macro to do what you want.

Visual Basic Editor view:

10 Useful Examples of Macros for Accounting:

1. Macro: Save All

Visual basic code samples for excel templates

Helpful for saving all open excel workbooks at once. It is advised to run this macro before running other macros or performing tasks that’s could potentially freeze Microsoft Excel.

Name this macro ‘SaveAll’

Example code:

Microsoft Visual Basic For Excel

2. Macro: Comments and Highlights

Helpful is you use a lot of comments and highlights while editing worksheets. Running this macro generates a new tab at the front of the worksheet with a listing of every cell with a comment or highlight in the workbook. Each cell reference is a hyperlink that leads directly to the cell with the comment/highlight. The summary tab lists the value within the cell and the text in the comment.

Additionally, there is an ‘Accept’ button that removes the highlight or deletes the comment from the chosen cell. Once all changes are accepted, the summary tab will be deleted.

NB: This macro only sets up to find certain highlights of yellow, but this can be modified.

3. Macro: Insert a Check Mark

Helpful for footing (Adding a column of numbers) trial balances, schedules and reconciliations. It is often common to put a check mark below the total to show the column total is accurate.

This macro will insert a red check mark in the active cell. Once this is added all you will be required to do is select the cell you want to check-mark in and run the macro. Name this macro ‘Checkmark’.

Example code:

4. Macro: Mail Workbook

Helpful to send a lot of excel files via email. Running this macro creates a new Microsoft Outlook email with the last saved version of the open workbook. The email, by default, will not be addressed by anyone, the subject will be the name of the workbook, and the body will be ‘See attached’. However, these settings can be customized.

Example code:

5. Macro: Copying the Sum of Selected Cells

Helpful in copying the sum of several cell in a spreadsheet. These cells can be scattered throughout the spreadsheet or all in the same row/column.

Once this macro is added you need to highlight the cells you want to sum, then run the macro, and then paste into the cell you want the sum in.

NB: This will just paste the value of the sum, not a sum() formula

Example code:

6. Macro: Open Calculator

Helpful to open a calculator.

Example code:

Sub OpenCalculator()
Application.ActivateMicrosoftApp Index:=0
End Sub

7. Macro: Refresh All Pivot Tables

Helpful to refresh all pivot tables in the whole workbook in a single shot.

Example code:

8. Macro: Multiply all the Values by a Number

Helpful if you have a list of numbers you want to have multiplied by a particular number. Select the range of cells you need and run the example code below. It will first ask you for the number with whom you want to multiply and then instantly multiply all the numbers in the range with it.

Example code:

9. Macro: Add a Number to all the Numbers in Range

Visual Basic Code Samples For Excel Template

Similar to multiplying, you can also add a number to all the numbers in a particular range.

Example code:

10. Macro: Remove Negative Signs

Visual Basic Code Samples For Excel Spreadsheet

Code that checks a selection and converts all the negative number into positive. Select a range and run th