On Sat, 23 Feb 2008 16:00:22 +0100, Sybmathics
wrote:

Dave Peterson schreef:
VBA has its own version. Look at InStr in VBA's help.



I have no problem with Find.

I have a problem with date or value.

Are there vba alternatives for the excel worksheetfunctions like date or
value


TIA

Sybolt

DateSerial in VBA works pretty much the same as the DATE worksheet function,
but it can use a wider range of dates.

The Value function in VBA is very different from the Value function in Excel as
it will ignore trailing text in the string, converting what it can starting at
the beginning of the string.

If you want to convert strings to values, and have an error message if the
whole string cannot be converted, you could use a data conversion function like
CDbl.
--ron