LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default debug not working

Your top level subroutine or function probably has parameters or the
parameter list has an error. first try setting the Brek option in VBA as
follows from VBA menu

tools - Options - general - Break On Error

If you have a parameter list at your top level you can write a subrouting to
call your code. Define the parameter list to match you module.


Sub Test

Dim Param1 as Variant
Dim Param2 as Variant
Dim Param3 as Variant
Call Yourcode(param1, param2, param3)

end Sub



"JimRich" wrote:

I have some code that I am trying to fix and wanted to step through the code.
When i clicked on "Step Into" nothing happend. No other code is running.
The cursur is inside the sub routine. I have other code that is being
exicuted when i just run it but even with a breakpoint set it does not stop.
Is there a way to turn "Debug" back on?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP Debug [email protected] Excel Programming 3 February 12th 08 03:28 AM
DeBug Ollie Excel Discussion (Misc queries) 4 April 28th 06 03:17 PM
Debug VBA Paul Cowan Excel Programming 0 December 9th 04 01:11 PM
debug Frank Kabel Excel Programming 0 September 22nd 04 06:22 AM
debug help Tom Ogilvy Excel Programming 0 August 27th 03 07:10 PM


All times are GMT +1. The time now is 10:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"