ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Run-time error '380' (https://www.excelbanter.com/excel-programming/439564-run-time-error-380-a.html)

Costas Limassol[_2_]

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?


All times are GMT +1. The time now is 09:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com