View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Costas Limassol[_2_] Costas Limassol[_2_] is offline
external usenet poster
 
Posts: 13
Default Run-time error '380'

Back in 2003 I created a macro for a form that was working fine. I haven't
used it since but now that I need it, I get all these strange errors that I
am sure where not there back in 2003 (e.g. I had to in include VBA in the
following line:
txtBirth.Value = VBA.Format(spnBirth.Value, "d-mmm-yyyy")

Now my problem is with the code:
spnDOE.Value = Date
when I get a run-time error 380 that it could not set the value property.
Invalid property value.

Any ideas?