Excel VBA 2010 Lesson 5: Writing the Code

[Lesson 4][Table of Contents][Lesson 6]

If you have learned the basics in Visual Basic programming, you will not face any problem in writing Excel VBA 2010 code. The syntax of Excel VBA 2010 is not much different from that of Visual Basic. However, for those of you who are new to Visual Basic programming language, please refer to our Visual Basic Tutorial and Resource Center.

In order to write the Excel VBA 2010 code, you need to use the Excel VBA 2010 Editor. The simplest way to launch the Excel VBA 2010 Editor is to insert an Active-X control as shown in Figure 5.1.


vba2010_fig5.1

The most common Active-X control we use is the command button. Proceed to insert the command button . Click on the Active-X command button to enter the Excel VBA 2010 editor. In the editor, you will be presented with the following program structure where you can enter code in between.

Private Sub CommandButton1_Click()

Your Code

End Sub

Excel VBA 2010 code is event driven therefore it will response to certain events. In the aforementioned example, it will execute when the user click on the command button.

Try the following examples:

a)
Private Sub CommandButton1_Click()

Msgbox “Welcome to Excel VBA 2010”

End Sub

b)

Private Sub CommandButton1_Click()

Dim YourMsg As String
YourMsg = “Welcome to Excel VBA 2010”
MsgBox YourMsg

End Sub


c)

Private Sub CommandButton1_Click()

Dim x,y As String
x=105
y=20
MsgBox x mod y

End Sub

* Running the program with return the value of 5

d)

Private Sub

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

End Sub

Running the code produces the sentence  “Tom likes to eat burger”

It produces the same effect if we replace the last line with MsgBox A & B & C & D & E




[Lesson 4][Table of Contents][Lesson 6]

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn