Dear Experts,

Normally, I use the evaluate formula to see how the calcs are performed.
However, there is a program that was created using Visual Basic. I am not
able to see the calculations behind it. How do I access this?

I have the password to get into this program via Visual basic editor but I
all I see is VB language etc.

Is there a way I can see the figures being calculated?
Kind Regards

Ed

You nee to add a break point in the VBA code and the debug the code in VBA.
OPen the workbook with the macro. the click on the first line of the
Function (or Sub) and Press F9. Here are some simple debug techniques

1) Use F8 to step through code
2) Use F9 to add more break points
3) Use F5 to run until a break point is reached
4) Hover mouse over variables to see the values of intermediate variables
5) At WATCH items to the debug envirnoment. Highlight variable with mouse
and then right click mouse. Select ADD Watch
6) Add debug stements into the code

debug.print myvariable where myvariable is any items in the code you want to
monitor any changes.

"Eddie Morris" wrote:

Dear Experts,

Normally, I use the evaluate formula to see how the calcs are performed.
However, there is a program that was created using Visual Basic. I am not
able to see the calculations behind it. How do I access this?

I have the password to get into this program via Visual basic editor but I
all I see is VB language etc.

Is there a way I can see the figures being calculated?
Kind Regards

Ed

Joel,

Thanks for your tip. Much appreciated.

Regards
Ed

"Joel" wrote:

You nee to add a break point in the VBA code and the debug the code in VBA.
OPen the workbook with the macro. the click on the first line of the
Function (or Sub) and Press F9. Here are some simple debug techniques

1) Use F8 to step through code
2) Use F9 to add more break points
3) Use F5 to run until a break point is reached
4) Hover mouse over variables to see the values of intermediate variables
5) At WATCH items to the debug envirnoment. Highlight variable with mouse
and then right click mouse. Select ADD Watch
6) Add debug stements into the code

debug.print myvariable where myvariable is any items in the code you want to
monitor any changes.

"Eddie Morris" wrote:

Dear Experts,

Normally, I use the evaluate formula to see how the calcs are performed.
However, there is a program that was created using Visual Basic. I am not
able to see the calculations behind it. How do I access this?

I have the password to get into this program via Visual basic editor but I
all I see is VB language etc.

Is there a way I can see the figures being calculated?
Kind Regards

Ed