Thread: text to date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andrew andrew is offline
external usenet poster
 
Posts: 6
Default 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