Page History

Info
The tutorials on VBA will include be included as both videos and text. If you have feedback on either, please leave a post on our Forum or send us a mail.

Panel

Table of Contents

First time using VBA

Our first encouter with VBA will be to display the familiar "Hello World" message using a button.

Expand

title	Hello World tutorial, text

Choose the "Developer" tab and open the VBA editor. If you don't locate the VBA editor, follow this guide. The following window will then open.
To write our first macro, choose "Instert" -> "Module".
First, we will make a Sub procedure that we may later add to our button. All Sub procedures have to begin with Sub and end with End Sub. A Sub can not return a value, and may be compared with a program in other programming languages, where as a function is an alternative. We then call the MsgBox function to create a new window displaying our message.
Lets now return to our Excel sheet to add the button. The insert button feature is shown in the image below.
Info
Tips: To align the size of the button with the existing columns and rows, hold down ALT while resizing. This applies to all sizings!
A new window will open. Choose the "Hello World" macro we just created and click "OK".
We may then rename our button by right-clicking on it and choosing "Edit text".
Finally, we can test our macro by clicking on the button. A window displaying the message "Hello World!" should then open.
If it does, congratulations! You have just made your first macro using VBA.

Expand

title	Hello World tutorial, video without audio

View file

name	Hello World VBA.mp4
height	250

Multimedia

name	Hello World.mp4
page	test

BibTeX Display Table