F
FCC
Hi,
I am using the Workbook_Open() to open a form that I've built in VBA.
The Sub is very simple:
Code:
--------------------
Private Sub Workbook_Open()
printerSettingsForm.Show
End Sub
--------------------
The only problem is when running this I get the
the fact I haven't properly declared or instaniated the object/Form
printerSettingsForm.
I tried goggling, but I couldn't find the proper technique to declare
an object. So I was wondering how I could fix this problem?
I am using the Workbook_Open() to open a form that I've built in VBA.
The Sub is very simple:
Code:
--------------------
Private Sub Workbook_Open()
printerSettingsForm.Show
End Sub
--------------------
The only problem is when running this I get the
And it centers on the sub. I am assuming the problem has to do withRun-time error '424'
Object required
the fact I haven't properly declared or instaniated the object/Form
printerSettingsForm.
I tried goggling, but I couldn't find the proper technique to declare
an object. So I was wondering how I could fix this problem?