G
Guest
I have this file that has only 1 generic userform had been loading upon
clicking a commandbutton. The command buttons are generically called
commandbutton1 on 12 different worksheets and are such:
Private Sub CommandButton1_Click()
loadform
End Sub
sub Loadform is located in module 1 and goes like this:
Sub loadform()
Load UserForm1
UserForm1.Show
End Sub
When I say generic, I mean that I just save the old one as a new file name
and clear out some values in some cells. However, I am now getting an error
message that reads that there is a runtime error 1004 due to
application-defined or object-defined error. This should be a very simple
yet stupid thing that I am overseeing. I haven't not changed the code for
the userform initialization and when I go back to the files created in the
prior months, I do not run into this problem. Is it possible the file and/or
userform has gotten corrupted as it is often operated in Share mode?
clicking a commandbutton. The command buttons are generically called
commandbutton1 on 12 different worksheets and are such:
Private Sub CommandButton1_Click()
loadform
End Sub
sub Loadform is located in module 1 and goes like this:
Sub loadform()
Load UserForm1
UserForm1.Show
End Sub
When I say generic, I mean that I just save the old one as a new file name
and clear out some values in some cells. However, I am now getting an error
message that reads that there is a runtime error 1004 due to
application-defined or object-defined error. This should be a very simple
yet stupid thing that I am overseeing. I haven't not changed the code for
the userform initialization and when I go back to the files created in the
prior months, I do not run into this problem. Is it possible the file and/or
userform has gotten corrupted as it is often operated in Share mode?