Conditional Breakpoint?

's Computer Specifications

I'm trying to debug a fairly hefty Macro. I need to tell it to break "When
myVar = yadda" so that I can see where it is running off the rails. Excel
Help doesn't even recognize the word "breakpoint" -- AAAAAAAAAAAARGHHHHHHHH!!
--
Dave
Temping with Staffmark
in Rock Hill, SC

's Computer Specifications

Never mind -- I found it under Watch. GRRRRRRRRRR!
--
Dave
Temping with Staffmark
in Rock Hill, SC

"Dave Birley" wrote:

> I'm trying to debug a fairly hefty Macro. I need to tell it to break "When
> myVar = yadda" so that I can see where it is running off the rails. Excel
> Help doesn't even recognize the word "breakpoint" -- AAAAAAAAAAAARGHHHHHHHH!!
> --
> Dave
> Temping with Staffmark
> in Rock Hill, SC

's Computer Specifications

Dave,
watches are not kept between sessions, so you have to set them each time you
open the file.
There also Debug.Assert. e.g. depending on what you need:

Debug.Assert myVar = "yadda"
Debug.Assert NOT (myVar = "yadda")

NickHK

"Dave Birley" <(E-Mail Removed)> wrote in message
news:CC8D488E-36F2-47E2-B00F-(E-Mail Removed)...
> I'm trying to debug a fairly hefty Macro. I need to tell it to break "When
> myVar = yadda" so that I can see where it is running off the rails. Excel
> Help doesn't even recognize the word "breakpoint" --
AAAAAAAAAAAARGHHHHHHHH!!
> --
> Dave
> Temping with Staffmark
> in Rock Hill, SC

's Computer Specifications

Ah -- so my voyage of self-discovery wasn't the only solution! Thanks.
--
Dave
Temping with Staffmark
in Rock Hill, SC

"NickHK" wrote:

> Dave,
> watches are not kept between sessions, so you have to set them each time you
> open the file.
> There also Debug.Assert. e.g. depending on what you need:
>
> Debug.Assert myVar = "yadda"
> Debug.Assert NOT (myVar = "yadda")
>
> NickHK
>
> "Dave Birley" <(E-Mail Removed)> wrote in message
> news:CC8D488E-36F2-47E2-B00F-(E-Mail Removed)...
> > I'm trying to debug a fairly hefty Macro. I need to tell it to break "When
> > myVar = yadda" so that I can see where it is running off the rails. Excel
> > Help doesn't even recognize the word "breakpoint" --
> AAAAAAAAAAAARGHHHHHHHH!!
> > --
> > Dave
> > Temping with Staffmark
> > in Rock Hill, SC
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
conditional breakpoint in C#, vs2005	Paul	Microsoft ASP .NET	1	15th Dec 2008 06:25 PM
Really weird - Code acting as though breakpoint set, no breakpoint	BlueWolverine	Microsoft Access VBA Modules	6	13th Mar 2008 04:20 PM
Problem with the breakpoint hitting(at runtime breakpoint was disa	Ranjit	Microsoft Dot NET Compact Framework	0	23rd Feb 2008 06:56 AM
Breakpoint ok, no breakpoint messes up...	Vikxcel	Microsoft Excel Programming	0	4th Jan 2006 09:18 PM
project stops at imaginary breakpoint, but no breakpoint exists	Mark	Microsoft ASP .NET	4	26th Apr 2004 05:23 AM