How does it fail?

If it fails on the Right() or CLng() portion, it could be caused by a missing
reference.

Open up one of those workbooks that won't work (on the failing pc).
Go into the VBE and select your project.

Then click on Tools|References

Look for MISSING in that list.

A missing reference will cause the procedure to not compile--and might point at
any old line.

Once you find that missing reference, you'll either have to deselect it or find
what it is and correct it.

=====
Or could it be as simple as that textbox3.text didn't have 4 digits at the far
right???



Francis Brown wrote:

nYear = CLng(Right(TextBox3.Text, 4))

Could anyone tell me why the above code works in some excel versions yet in
others it does not.

xl 97 at work keels over yet mine does not.
--
Regards and Thanks for any assistance.

Francis Brown.

--

Dave Peterson