Workbook_Open() and Object Not Found

[FCC]

Hi,

I am using the Workbook_Open() to open a form that I've built in VBA. The Sub is very simple:

Please Login or Register  to view this content.

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?

[Tim Marsh]

hi,

try including the following line before the .show line

load printerSettingsForm

hth

tim

"FCC" <[email protected]> wrote in message
news:[email protected]...
>
> 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?
>
>
> --
> FCC
> ------------------------------------------------------------------------
> FCC's Profile:
> http://www.excelforum.com/member.php...o&userid=35888
> View this thread: http://www.excelforum.com/showthread...hreadid=558279
>

[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

[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.