Not necessarily true that that's where the error lies. Look at all of your
code to see.

--
Don Guillett
SalesAid Software

"LT" wrote in message
oups.com...
Hello all.

I was wondering if by chance there is a limit to how much code you can
type into a vba Excel document. Is there a limit on how much code can
go into one button or an entire userform?

I ask this cause I get this error message;

"Compile Error:
Only comments may appear after End Sub, End Function or End Property"

When it jumps me to see what's "wrong" it goes to highlight this line
of code that is in the middle of a bunch of code.

txtApt.Locked = True

Which, to my knowledge has nothing to do with why the errors that are
being generated.

I'm hoping one of you out there might have some knowledge to share on
any quirks with Excel and VBA.

Thanks in advance.

-LT