Hi. hope you guys are having a good day. So, i just wanted to know, while running a macro, is it possible to check the code like which data it is picking up, from which sheet, etc. Similar to what we can see in calculation steps on errors in normal excel sheets.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
checking calculation steps in vba modules
- Thread starter Shardey
- Start date
L
Legacy 143009
Guest
Hi! That's what compilers are for! Breakpoints are sort of bookmarks where you want to pause the code on the run.
All you have to do is
1.Simply click to the left pane that aligns with the line of code you want to give a break. The line will be highlighted in red.
2. Select the variable you want to watch and click right mouse button. Select "Add Wach" in the context menu:
3. Enable Watch window from View menu in VBA window. You will see your variable is listed in this window:
4.When you run the code, the procedure will stop at the breakpoint and be highlighted in yellow. You can examine the parameters of that object such as Properties, Type, Value, etc.. and even manipulate them on-the-fly:
In my example, I would like to see the sheet's name stated in
All you have to do is
1.Simply click to the left pane that aligns with the line of code you want to give a break. The line will be highlighted in red.
2. Select the variable you want to watch and click right mouse button. Select "Add Wach" in the context menu:
3. Enable Watch window from View menu in VBA window. You will see your variable is listed in this window:
4.When you run the code, the procedure will stop at the breakpoint and be highlighted in yellow. You can examine the parameters of that object such as Properties, Type, Value, etc.. and even manipulate them on-the-fly:
In my example, I would like to see the sheet's name stated in
With statement. I hope these steps will help in your future projects.
Last edited by a moderator:
Upvote
0
Solution
