Excel Visual Basic for Applications

FAQ About Excel Visual Basic for Applications

Where can I see the results of my codes that I wrote in Excel?

We can see the results of the codes with a message box or we can send them to a cell.

The code you need to write to display it with the message box;

Result: The name of the variable with the result value.

  • MsgBox result

When you run this code, you will see a message box pop-up with the result.

But let's say you want to display the result in cell A1. Then the code you need to write;

  • Range("A1") = result

When you run the code, the result will be written in cell A1.