ExcelBanter

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

Fred Holmes

Run-Time Error '380'
 
Excel 2000. Windows 2000. I have a UserForm, "UserForm1", encoded into
a particular workbook. I've been using the workbook "forever." The
UserForm has always worked.

All of a sudden, the code statement:

UserForm1.Show

which has always worked, now returs an error:

Run-time error '380': Could not set the Value property. Invalid
property value.

And, of course, the UserForm1 does not appear.

The UserForm1 is there in the workbook. Both "View Code" and "View
Object" seem to show exactly what I would expect, although I have not
performed a word-by-word examination of the code.

Where do I begin to look for the cause of this error? What would have
caused it? I don't recall making any recent changes to any of the
code in the workbook, although I do make refinements to the code in my
workbook from time to time, and I haven't used this workbook for
several days.

I can probably recover from a rolling backup, but it would likely mean
re-entering a bunch of data into the workbook.

Thanks,

Fred Holmes


All times are GMT +1. The time now is 05:15 PM.

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