Workbook_Open() and Object Not Found

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
Run-time error '424'

Object required
And it centers on the sub. I am assuming the problem has to do with
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?
 
T

Tim Marsh

hi,

try including the following line before the .show line

load printerSettingsForm

hth

tim
 
L

Leith Ross

Hello FCC,

Since you are opening the workbook, Excel doesn't know the user form is
an object in the workbook. Try this method...

With ThisWorkbook
Load .PrinterSettingsForm
..PrinterSetttingsForm.Show
End With

Sincerely,
Leith Ross
 
F

FCC

It's funny. I changed the name of my form to userForm and everything
worked fine after that.

It's like Excel doesn't recognize any form objects not named userForm
unless you declare them using the Load button.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top