Next, it stores the value found in Cell C4 to the stockPrice variable. It creates a new Single variable (a number data type that allows non-integers) named stockPrice. The macro now has two processes to perform. Now that we’ve created the stockPrice variable, we want to store a value in it. Stock Price would be written as stockPrice. Recall that the generally accepted naming convention for variables is to use lower case if there is only one word, and to introduce every word after the first with a capital letter. We are going to be using one variable here to store the value of Nikolai Motors stock price. The very top of every macro should contain variable declarations. The first step in creating a macro is naming the macro, as shown below. To begin creating the macro, we open the VBA Editor by pressing Alt + F11. To learn more, launch our online Excel VBA Course! Naming the Macro has the exact same stock price as Nikolai Motors right now. However, creating this macro will allow you to see how to write a macro and the general logic behind VBA programming.Īs you can see below, Turtle Dove and Capital Inc. For the purpose of this exercise, we are going to create a macro that will perform a function that can easily and more quickly be done manually. We are going to try and insert data into the cells to complete the table. For this example, let’s assume we have the following data table.

Visual basic for excel examples