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.

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

The text box is always in format xx-xx-xxxx in UK date format. day first.

if the line is swapped for

nYear = CLng(Mid(TextBox3.Text, 7, 4))

then it works.

The left function also works fine.

As I said the function works on my XP system with xl97. when I run it on NT4
at work with xl97 it fails. The code compiles. It is when it is running the
function it fails.

Thanks for input

Francis.
--
Regards and Thanks for any assistance.

Francis Brown.


"Dave Peterson" wrote:

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

I think I'd double check the .text

if isnumeric(right(textbox3.text,4)) then
nyear = clng(...)
else
msgbox textbox3.text & " isn't correct"
....

Francis Brown wrote:

The text box is always in format xx-xx-xxxx in UK date format. day first.

if the line is swapped for

nYear = CLng(Mid(TextBox3.Text, 7, 4))

then it works.

The left function also works fine.

As I said the function works on my XP system with xl97. when I run it on NT4
at work with xl97 it fails. The code compiles. It is when it is running the
function it fails.

Thanks for input

Francis.
--
Regards and Thanks for any assistance.

Francis Brown.

"Dave Peterson" wrote:

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


--

Dave Peterson