Quick beginner question-Why doesn't On Error Exit Function work?

Just a quick question that's stumping me. I have boolean functions. Whenever I enter '

Please Login or Register  to view this content.

' I get a syntax error. Why?

You cannot use Exit function with On Error.

Instead try like this...

Please Login or Register  to view this content.

Originally Posted by :) Sixthsense :)

You cannot use Exit function with On Error.

Instead try like this...

Please Login or Register  to view this content.

Thanks. That's what I have been doing.

But why can't you use Exit Function on Functions?

As far as I know there is only 3 type of error handler in VBA.

Please Login or Register  to view this content.

plus

Please Login or Register  to view this content.

Originally Posted by JosephP

plus

Please Login or Register  to view this content.

Also

Please Login or Register  to view this content.

in Subs. But my question is - why don't Functions have an equivalent to this? I find it inconsistent.

Originally Posted by mc84excel

Also

Please Login or Register  to view this content.

in Subs

that is not valid syntax

Originally Posted by JosephP

that is not valid syntax

You're correct.

(Puzzled. I was so certain that I used On Error Exit Sub in code in the past without any syntax errors. I must have been getting mixed up with something else).

Since On Error Exit Sub doesn't work either (my mistake everyone - it's been a long week) then there is no inconsistency and this thread is pointless. Marking "solved" now. (Pity we can't delete nonsense threads)

you may find it useful to have the vba language specification document http://download.microsoft.com/downlo...MS-VBAL%5D.pdf

there's some weird stuff in there ;-)

Originally Posted by JosephP

you may find it useful to have the vba language specification document http://download.microsoft.com/downlo...MS-VBAL%5D.pdf

there's some weird stuff in there ;-)

THANKS! Now this IS interesting. :D

(With luck I might find something on my question for info on the lifetimes of changes to Application Properties - which other forum users appear to think I am wasting my time on!)

you won't-it's the specification for the vba language not a particular object model

Originally Posted by JosephP

plus

Please Login or Register  to view this content.

Ah~~! I totally forgotten it and unable to retrieve from memories for which purpose it is used for

it both deactivates the current error handler and clears the current exception. I know of no good reason to ever use it :-)

Thanks for the explanation and correction