Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I view the value of a variable in my code?
There are a few things you can do:
1) Put MsgBox MyVar at various places in code if you want to pop up the values from time to time to see what is happening. 2) If the code is paused (break mode) you can use the immediate pane and print the values, e.g.: print MyVar or simply: ? MyVar 3) Open up the locals Window: it shows the current value of all variables in a "tree" type structure (for the objects) Immediate Pane and Locals window are available in View menu "Bill_S" wrote: In the VBA window how can I check the current value of one of the variables in my code? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I view the value of a variable in my code?
Thank you. Inserting the MsgBox MyVar within the code was helpful.
"K Dales" wrote: There are a few things you can do: 1) Put MsgBox MyVar at various places in code if you want to pop up the values from time to time to see what is happening. 2) If the code is paused (break mode) you can use the immediate pane and print the values, e.g.: print MyVar or simply: ? MyVar 3) Open up the locals Window: it shows the current value of all variables in a "tree" type structure (for the objects) Immediate Pane and Locals window are available in View menu "Bill_S" wrote: In the VBA window how can I check the current value of one of the variables in my code? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
View the code in a add-in | Excel Worksheet Functions | |||
can i link a variable cost code with a variable sum | Excel Discussion (Misc queries) | |||
VBA Code to switch view | Excel Programming | |||
Capture Custom View in a Variable | Excel Programming | |||
Mouse in Code View | Excel Programming |