K keepitcool Nov 14, 2003 #2 use STEP into/out (F8) in debug menu in VBE or first set some breakpoints with F9, then fire up your procedures and they will stop on the breakpoints. If the LOCALS window is visible, you can see all your variables, or add some watches on variables you'd like to monitor. keepITcool < email : keepitcool chello nl (with @ and .) > < homepage: http://members.chello.nl/keepitcool >
use STEP into/out (F8) in debug menu in VBE or first set some breakpoints with F9, then fire up your procedures and they will stop on the breakpoints. If the LOCALS window is visible, you can see all your variables, or add some watches on variables you'd like to monitor. keepITcool < email : keepitcool chello nl (with @ and .) > < homepage: http://members.chello.nl/keepitcool >
L Louis Nov 14, 2003 #3 It worked! thanks I didn't really understand how I could watch the state of my variables as the macro excecutes itself. I'm running Excel97 Thanks for your help so far.
It worked! thanks I didn't really understand how I could watch the state of my variables as the macro excecutes itself. I'm running Excel97 Thanks for your help so far.
D Dave Peterson Nov 15, 2003 #4 Ignore this message if you understand it now. (I wasn't sure if you didn't before or don't currently.) When you're stepping through your code, you can let the cursor linger over a variable and you'll see a tooltip pop up with its current value. You can also rightclick on a variable and select "Add Watch" Then you can see the watch window by: View|Watch window (if you closed it)
Ignore this message if you understand it now. (I wasn't sure if you didn't before or don't currently.) When you're stepping through your code, you can let the cursor linger over a variable and you'll see a tooltip pop up with its current value. You can also rightclick on a variable and select "Add Watch" Then you can see the watch window by: View|Watch window (if you closed it)
