Now we can use this function to quickly test the data type of a given variable. Syntax: Debug.Print Strings to print The code below demonstrates how to print using the Debug.Print. It will allow you to test the code on a more granular level. It’s very helpful when it comes to program development.

One of the tool’s uses is its ability to print strings and values.

This tool allows you to test individual lines of code, which is useful when you are writing and debugging code. Print Information in the Immediate Window in Excel VBA. I listed above all values within the VBA Enum called VbVarType. Using Debug.Print Using the Immediate Window When Running Code The VBA Immediate Window is used to quickly run lines of VBA code, as well as fetch information about your code or Excel file.

To exemplify the usage of the VBA VarType function let us create a custom VBA Sub called PrintType that will print in the Immediate window the name of the data type we provide: The syntax for the VarType function in VBA is: VarType ( expression )Ī VBA variable for which we want to learn the VbVarType.

Excel vba debug print time