close

i am troubleshooting some code i wrote, and it would be very helpful to
know the command for running the code line-by-line so i can identify my
error more quickly. thanks.--
honestlylion
------------------------------------------------------------------------
honestlylion's Profile: www.excelforum.com/member.php...oamp;userid=31674
View this thread: www.excelforum.com/showthread...hreadid=516195quot;honestlylionquot; gt;
wrote in message
news:honestlylion.23qoza_1140794400.9802@excelforu m-nospam.com...
gt;
gt; i am troubleshooting some code i wrote, and it would be very helpful to
gt; know the command for running the code line-by-line so i can identify my
gt; error more quickly. thanks.

While in the code editor, click on Help, start the help system, and search
for the word quot;Stepquot;. That'll tell you how, assuming Excel uses the same
terminology as every other programming language on earth.
Have a look at the Debug menu in the VBA window: it shows the
options and shortcuts, e.g. F8 to step through the code.
You can also make a line a Breakpoint (F9), which will make the
debugger stop when it reaches the line.honestlylion wrote:
gt; i am troubleshooting some code i wrote, and it would be very helpful to
gt; know the command for running the code line-by-line so i can identify my
gt; error more quickly. thanks.
gt;
gt;
gt; --
gt; honestlylion
gt; ------------------------------------------------------------------------
gt; honestlylion's Profile: www.excelforum.com/member.php...oamp;userid=31674
gt; View this thread: www.excelforum.com/showthread...hreadid=516195

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()