Re: VBA Debug Mode : How to I enter it after executing the nth data row.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



On Jun 17, 5:55 pm, u473 <u...@xxxxxxx> wrote:
My program performs well until I reach execution of data row # 1378.
My loop seems to be misbehaving after that row but I have no clue on
what triggered it.
Please remind me how do I enter automatically in VBA Debug Mode after
executing
the nth data row to be able to start checking Watches.
Thank you,
Wayne

An alternative is to display a Msgbox when the row count is n and as
the msgbox gets displayed u can press ctrl+break and then it will take
u to the debug mode and then u can put all the break points !
.



Relevant Pages

  • Re: do pop up boxes stop all events?
    ... If you display a standard VB MsgBox when your code is running in the VB ... Timers and various other events will still work fine while the dialog is ... sub) are also halted. ...
    (microsoft.public.vb.general.discussion)
  • Re: boolean localization problem
    ... What you're seeing is an artifact of using MsgBox for output display. ... text representation (probably by using CStr() internally). ...
    (microsoft.public.scripting.vbscript)
  • Re: VB Popup Alert Help?
    ... "Chip Pearson" wrote: ... MsgBox "We're Done",vbOkOnly ... You can also display a message box that will automatically close after ... I also used to have a script that popped up an alert window when a script ...
    (microsoft.public.excel.programming)
  • Re: Custom Meeting Request form
    ... I just found the syntax issue and its working now the Form selection and ... and display in text field on click of button in the Custom form. ... Msgbox "hi" ... The VBA environment is still useful, of course, for prototyping code and for looking up Outlook property names in the object browser. ...
    (microsoft.public.outlook.program_forms)
  • Re: VB Popup Alert Help?
    ... MsgBox "We're Done",vbOkOnly ... You can also display a message box that will automatically close after ... I also used to have a script that popped up an alert window when a script ...
    (microsoft.public.excel.programming)