Formula evaluation in excel prgram created with VB

E

Eddie Morris

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
 
J

Joel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top