Re: F8 and Yellow pattern for compile error

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

From: Hari Prasadh (excel_hari_at_hotmail.com)
Date: 01/30/05 

Date: Sun, 30 Jan 2005 20:49:59 +0530

Hi Bob,

Im sorry, I used *recursion* word as a pun.

I mean I find it very hard to debug the error. So, when-ever there is a
yellow line, I would change a small detail within that ( remember my
yesterday's post regarding "Cleaning up the syntax" where I was at my wit's
end and I provided 3 variations -- a) , b) , c) -- of changes I tried) and
see whether it works. So in effect I keep *permuting* the various possible
*syntaxes*.

Now when Iam playing this *game* sometimes VBA would reset my project and
sometimes its very graceful and allows with the continuation of the rest of
the code.

I wanted to *predict* when VBA would reset and when it wouldnt.

Thanks a lot,
Hari
India

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:%237$yestBFHA.936@TK2MSFTNGP12.phx.gbl...
> Hari,
>
> I see you have got no replies to this, so I will take a shot.
>
> You mention recursive mode. I am not absolutely clear what you mean by
> this,
> but does this mean that your code uses recursion. Are you handling the
> recursion exits properly, not choking up the stack?
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Hari Prasadh" <excel_hari@hotmail.com> wrote in message
> news:OAgr12UBFHA.3492@TK2MSFTNGP12.phx.gbl...
>> Hi,
>>
>> When I get an error, the offending line in my code would be having a
> streak
>> of yellow pattern.
>>
>> As is my habit, I would make a minor change (I play a game of odd-man-out
> in
>> recursive mode with VBA) to the code Line and herein lies my doubt.
>>
>> a) Sometimes when I make the change I would get the deadly message box
>> (vbokcancel) something on the following lines "Project needs to be
>> RESET."
>>
>> b) And rest of the times VBA would be very kind and would allow the
>> change
>> in the code line, WITHOUT Resetting and I can continue with the code
>> execution (unless more errors pop up in the same line)
>>
>>
>> Whats the logic for the above behaviour. Can I predict in what kind of
>> changes , VBA would reset my project and when it would not.
>>
>> Please guide me.
>>
>> Thanks a lot,
>> Hari
>> India
>>
>>
>
>

Relevant Pages

  • Re: VB6/Access Parent child relationship
    ... >> VBA is a limited subset of VB. ... > Sorry, Michael, but I think this is inaccurate. ... That might very well be correct - I would certainly assume that recursion is ... I wasn't saying that what the OP wanted couldn't be done in VBA, ...
    (microsoft.public.vb.database)
  • Re: Need help sorting a self join query
    ... I've never thought of using a recursive function in VBA. ... and did it in that language. ... I'll have to play with this a bit, ... See: Recursion. ...
    (microsoft.public.access.queries)
  • Re: F8 and Yellow pattern for compile error
    ... > recursive mode with VBA) to the code Line and herein lies my doubt. ... > something on the following lines "Project needs to be RESET." ...
    (microsoft.public.excel.programming)
  • Re: Scope Question
    ... How can I store a list such that it is not reset on each ... recursive call to the search function? ...   ... If you use a global variable for recursion context, ...
    (comp.lang.lisp)
  • Re: Scope Question
    ...   ... If your recursive function was in a LABELS, ... I forgot to mention that I would like the variable to reset itself on ... Although there is no recursion in that ...
    (comp.lang.lisp)