Simple code lines failing; error 9 confusion, For without Next...with next

[mikecox39]

I am testing; in the Immediate pane of the VBE, some of the example code in a book I am studying; in order to learn VBA.

Here are a couple that fail every time.

[/URL][/IMG]

I checked the Help option for error 9 but I didn’t understand it.

I’ve double checked the code; to make sure I entered it exactly as it is in the text, but it fails every time.

[/URL][/IMG]

This one has a "for" so why am I getting this error? Again, I double checked the example in the text and I have it written exactly as shown in the text.

Others, like “…comments.count” and “…Parent.address” work just fine.

 

[shg]

I agree with Norie -- I use the Immediate window a LOT, but not to write programs

 

[hiker95]

mikecox39,

Thanks for posting all these, I have bookmarked the reply for future reference.

Thanks for the feedback.

You are very welcome. Glad we could help.

And, come back anytime.

 

[mikecox39]

In the Immediate window:

For Each cmt in Activesheet.comments: msgbox cmt.parent.address & " " & cmt.text: Next cmt

Ok, I guess the author didn't expect the reader to try his example in the Immediate pane. Now that I realize code placed there should be on one line I won't try mult lines of code there again. I guess that's why the ones what worked worked; because they were one line.

 

[mikecox39]

I thought I was being clear,

I was referring to the axiomatic one liner; the general statements of obvious truth with nothing else. If you had continued with something like "you can't put multiple lines of code in the immediate pane" I wouldn't have had to wait for that gem to be revealed in your follow up to my crack about your one liner.

you can use it for multiline code blocks if you use the method shg posted, but I don't really see the point.

Why not stick the code in a temp sub?

Then you can loop through it (F8), examine the variables (Watch/Locals windows), set breakpoints, compile the code...

As I indicated at the outset; I'm a novice, I'm just learning about the VBE; what the panes are called and what is in them and what objects are, etc. I don't know what the shg method is, or what temp sub means or how to loop through it using F8.

PS 'all that'? My posts weren't exactly verbose.

No, but there were a lot of one liners.

 

[MARK858]

how to loop through it using F8

Mike in amongst Hiker's list is the link below, F8 comes under the header "Stepping through code"

Debugging VBA

 

[mikecox39]

Mike in amongst Hiker's list is the link below, F8 comes under the header "Stepping through code"

Debugging VBA

Thanks for pointing that out; I would never have found it I'm sure it will clarify a lot of my confusion.

 

[Norie]

temp sub - temp(orary) sub(routine).

 

[mikecox39]

temp sub - temp(orary) sub(routine).

I don't get it

 

[Norie]

If you want to test code you can create a subroutine and put the code in it.

That gives the advantage of being able to use various debugging tools.

For example you can step through the code line by line using F8, checking what's happening, variable values, code flow etc.

Once you're done testing the code you can simply delete the subroutine, hence 'temporary' subroutine.

 

[mikecox39]

I don't get it

Ok, I realized what this was about too late to edit it so I'll just say... I knew what the abbreviations stood for; that's obvious, I just don't know what a Temporary sub-routine is.

I know what a sub-routine is, everyone who's ever studied BASIC; and how hasn't, knows that. I also know what temporary is, I just don't know where to create a temporary subroutine; do you do it in the immediate pane or somewhere else? What is the syntax or how do you lay it out. Is it just a sub/end sub that you call temporary; to test a line a code; isn't that what the immediate pane is for?

Like I said; I'm a novice. I know how to drive a car but I've never driven this one; so I don't know where all the buttons are; I know what they do, I just need to discover how this car drives.

I think I should just continue my reading, I'm sure it will all fall into place soon. I've gotten a lot of great resources from everyone here, and I've found a new reference that I ordered yesterday; so I think I'm good to go.

I really appreaciate all the help I've gotten on this question; this is a really great forum !