Unpredictable userform errors

[hwkeyser]

Hey everyone,

I've been using a form i created for months now with a pop-up calendar for date input.

Just today though, every time it autosaves (or i assume that's the stimulus as it occurs about every five minutes), clicking the cell that pops up the calendar returns a "runtime error '75' Could not find specified object" and i can no longer access the frmCalendar userform.

I can access the code for the form, but neither the userform object nor the module which presents the userform properly open. When i try to open the object either way it returns a Microsoft VB "Path/File Access Error".

After I give up fixing it, close the file and re-open from the last save (or the autosave for that matter) The userform returns to working order for a period of time, then, when I just get back into the groove, RUNTIME ERROR 75 again.

someone please help because i haven't a clue why it has started doing this today and i'll paste every code i've got to help clear this up, but it's the standard microsoft frmCalendar object.

help

-HK

 

[kpark91]

I'm not too sure I may be much help but I'll try.

First, put your code up and I'll take a look at it.
Or even better, you can upload your workbook with the userforms and see what's up.

 

[hwkeyser]

I can't upload the entire workbook because of the data therein, but here's the portion which applies:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("G30,P30")) Is Nothing Then
    Module4.OpenCalendar
End If
End Sub

User Form Code:

Private Sub Calendar1_Click()
    ActiveCell.Value = Calendar1.Value
    Unload Me
End Sub


Private Sub UserForm_Initialize()
    If IsDate(ActiveCell.Value) Then
        Calendar1.Value = DateValue(ActiveCell.Value)
    Else
        Calendar1.Value = Date
    End If
End Sub

The calendar itself doesn't pull any data from anything on servers, networks, etc.. The overall file is stored on a server folder, but everything it pulls from is self-contained within the excel file (hence why i cant share it). I'm also not sure why this is just happening now as i've been using the same file for months without error.