Check if string contains a number

Is there way in Excel VBA to check if a string contains a number, and then return TRUE or FALSE. Numbers can been anywhere in the string. See example below.

Please Login or Register  to view this content.

Check this out

http://office.microsoft.com/en-us/ex...549011033.aspx

With A1 containing anything.

Here are two approaches:
Non-VBA:

Please Login or Register  to view this content.

Edited to include this shorter (but slightly less intuitive) alternative:

Please Login or Register  to view this content.

Using VBA:

Please Login or Register  to view this content.

Usage:

Please Login or Register  to view this content.

Does that help?

Alternative

Please Login or Register  to view this content.

Originally Posted by Shijesh Kumar

Alternative

Please Login or Register  to view this content.

I think that would return the count of digits in the referenced cell.

This would return 1 for cells containing numbers:

Please Login or Register  to view this content.

yes it will return count of digits..
so we can modify it as below to return true or false

Please Login or Register  to view this content.

One question thousand solution ;-)