hi Everyone,
Do you know how to list all the class module variables along with their "current" values during run-time?
This is similar to lookup the variables on the watch panel during run-time, but I am trying to list all of them to a worksheet using VBA.
Maybe I am not using a good enough keyword, but the best I can find on the internet is http://www.mrexcel.com/forum/showthread.php?t=502112
But Zack Barresse's solution is just to list all the variables defined in the module, not to list their values during run-time (Please correct me if I am wrong).
The reason that I am doing this:
I have around 20-30 public variables sitting in some class modules. Differnt subs/functions would change those variables. I want to see what values those variable have at different stages, so I wrote a "status" sub to print out the variable names and their value, and call this "status" sub in other subs/functions. However, this is not the ideal way to do as I have to hard code all the variable names in this "status" sub and I need to add/remove/re-arrange those variables very often, which is a problem.
Any suggestions/solutions/hints would be highly appreciated.
Thank you all in advance!!
Do you know how to list all the class module variables along with their "current" values during run-time?
This is similar to lookup the variables on the watch panel during run-time, but I am trying to list all of them to a worksheet using VBA.
Maybe I am not using a good enough keyword, but the best I can find on the internet is http://www.mrexcel.com/forum/showthread.php?t=502112
But Zack Barresse's solution is just to list all the variables defined in the module, not to list their values during run-time (Please correct me if I am wrong).
The reason that I am doing this:
I have around 20-30 public variables sitting in some class modules. Differnt subs/functions would change those variables. I want to see what values those variable have at different stages, so I wrote a "status" sub to print out the variable names and their value, and call this "status" sub in other subs/functions. However, this is not the ideal way to do as I have to hard code all the variable names in this "status" sub and I need to add/remove/re-arrange those variables very often, which is a problem.
Any suggestions/solutions/hints would be highly appreciated.
Thank you all in advance!!
