Excel VBA Type

In VBA, you can create your own data types using the Type keyword. It’s very similar to struct data type from other programming languages.

It consists of one or multiple existing types into one new type. A good example of using this data types is a database record. If you want to keep a record of your employees, it’s a good idea to use the Type structure.

A variable declared as Employee will have all these data types built-in. You declare user-defined types the same way you declare standard built-in VBA types.

Now, you can access individual fields of this structure by using the dot (.) operator. You can assign a value to any of the Employee types.

Now, you can display these elements. In this example, we are going to do it inside MsgBox.

In order to run this function, you have to create a new module inside the VBA editor (Left Alt + F11).

Copy the following code into the module you created.

Code explanation

The code is pretty straightforward. What probably needs explanation is the Long type in salary and the  Cstr function used in MsgBox.

The Long type is used, instead of Int because we deal with big numbers.

The Cstr function converts the numeral value into a string. Otherwise, the code will result in an error.

This code will return the following result.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.

Posted in vba