Work through VB code

  Desert Andy 12:21 02 Feb 2006
Locked

I have written a program in excel using VB code. The code is not working as I expected, is there a way of working through the code line by line seeing the values of the various variables as the program runs.

Thanks for your help.

  Rand Al Thor 12:39 02 Feb 2006

Debugging is a very involved subject. The Microsoft Knowlege base does have an excellent article on this subject though.

click here

  PaulB2005 12:53 02 Feb 2006

Press F8 to Step Into the Code. Then press F8 run each step and see where it fails.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Comment afficher des fichiers cachés sur Mac ?