Changes to some VBA

[Comfy]

Good Morning,

I've been tasked with updating and changing a Budget Upload workbook.

I'm just stepping through the code to understand how it works and a question has arisen.

When this wb was written the Public Objects were declared in their own module so when I do step through the code I cannot see each Objects Value in the Locals window.

Is there anywhere that I can see all defined Objects and their Values?

Thanks,
/Comfy

 

[obiron]

Can you add a watch? This will show the variable or object property you specify in a separate window below the code. It certainly works for local values, it should work for public globals as well.

 

[Comfy]

Ahh so that's what that's for.

Thanks Obiron.

Out of curiosity, will the watches save with the VB session or will I need to add them again if I close the wb?

/Comfy

 

[obiron]

you will have to add them again.

You can also add watches in the worksheet to monitor when cell values change. in XL2003 go tools->formula auditing->show watch window. These watches ARE saved with the workbook.

Obiron