VBA (Visual Basic for Applications) is the programming language used to create macros. A good knowledge of VBA can save time and make you a much more productive Excel user. VBA is a common programming language found in virtually all Microsoft Office applications. People will often learn VBA before progressing to other languages in due course.
Today I am going to show you how to create a welcoming message to anyone who uses you spread sheet. First thing we are going to do is to create a userform with our message in it use the lable tool to put the message into the form.
Once you have done that you will need to double click on the user form and it will take you to the place where you can write code for your user form. You will then need to add the code below to it if this is a new UserForm just delete the code that’s already there.
The next step will be creating a new module by going to insert then down to Module. Once you are in the new Module then you will need to put this code in below. As the code simply puts it will unload the UserForm.
This next art of code will need to go into the workbook and this is the code that will make the UserForm show whenever has been opened.
You should be greeted when you open you workbook by something that looks like this.