text to date
 

Hi,
Is there a way that I can convert month and year numbers into dates in
vba analagous to the "=Date()" function in excel. For instance, how
can I convert 12/2005 into a date number in vba without using "=Date"
in a worksheet cell?

Thanks,
Andrew

text to date
 

Hi Andrew,

Try:

'=============
Public Sub Tester002()
Dim DTE As Date

DTE = DateValue("12/2005")
MsgBox DTE

End Sub
'<<=============


---
Regards,
Norman



"andrew" wrote in message
oups.com...
Hi,
Is there a way that I can convert month and year numbers into dates in
vba analagous to the "=Date()" function in excel. For instance, how
can I convert 12/2005 into a date number in vba without using "=Date"
in a worksheet cell?

Thanks,
Andrew

text to date
 

Hi Andrew,

use the DateValue function, directly available in VBA

--
Kind regards,

Niek Otten


"andrew" wrote in message
oups.com...
Hi,
Is there a way that I can convert month and year numbers into dates in
vba analagous to the "=Date()" function in excel. For instance, how
can I convert 12/2005 into a date number in vba without using "=Date"
in a worksheet cell?

Thanks,
Andrew

text to date
 

Thanks! This is great