Type Mismatch VBA

When we try to assign a value between two different variable types, then an error occurs that is called the VBA Type Mismatch error.

This error occurs during the run time, such as “run-time error 13: Type mismatch”.

For example: If we provide a text value to an integer data type variable, then the Type mismatch error occurs during the execution time of the code.

We declare the variables in the code and assign the data types to it. We need to remember during providing the value to those variables that what kind of data it holds. If the provided value is not as per the data type requirement, then it throws the “Run Time Error 13: Type Mismatch” error.

Advantages of VBA Type Mismatch

Below are some advantages of the Type mismatch error, such as:

  • We know the actual mistake where it happened in the code.
  • Without the compilation of the code, we can get the point of error in the code.


Here are some steps to show the type mismatch error. Now, follow the following steps, such as:

Step 1: Click on the Developer tab.

Step 2: And click on the Visual Basic option.

Step 3: Then click on the Insert button on the pop-up window.

Step 4: Now insert a new Module.

Type Mismatch VBA

Step 5: Double click on the newly added Module; it opens a code window.

Step 6: Write a VBA code on the code window.

Type Mismatch VBA

Step 7: Next, define a variable “X” as an Integer data type.

Type Mismatch VBA

Step 8: Integer data type can store numbers and whole numbers only. But we assign a text value to the X variable.

Type Mismatch VBA

Step 9: We use the Message box to see the stored values in the X variable.

Type Mismatch VBA

Step 10: Execute the above code by clicking the Run button.

Type Mismatch VBA

After execution, it displays an error message “Run-time error ’13’: Type Mismatch”. The integer data type can only store the Numbers or Whole Numbers, but we assign the text value to the integer data type. That’s why it gives an error.

If we assign the right value to the variable, we will get the correct output, as shown below:

Type Mismatch VBA

Now execute the above code, it will give the correct output without showing any error.

Type Mismatch VBA

Example 2: Here is another example with the different data type, such as:

We define the variable “A” as Boolean. The Boolean data type can hold either True or False value only.

Type Mismatch VBA

We assign the value 100, but it is not as per the data type value.

Now execute the above code by clicking the Run button.

Type Mismatch VBA

After execution of the above code, it does not display any error message because excel treats all the numbers as True except zero, and zero is treated as False.

If we add a text value with the numeric value, then it displays an error, such as:

Type Mismatch VBA

Again execute the same code, now it will display the error as shown in the below screenshot, such as:

Type Mismatch VBA

Next TopicExcel VBA Objects

Previous articlePowerShell Tutorial
Next articleVBA Date Format