Run-Time Error '380'

[Fred Holmes]

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

 

[Guest]

If your value property is set to a worksheet reference source, you could have
changed that and cause the error. If it needs an integer and the source is
now text, it would cause the error.