Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open() and Object Not Found
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open() and Object Not Found
hi,
try including the following line before the .show line load printerSettingsForm hth tim "FCC" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open() and Object Not Found
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 -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=558279 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open() and Object Not Found
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. -- FCC ------------------------------------------------------------------------ FCC's Profile: http://www.excelforum.com/member.php...o&userid=35888 View this thread: http://www.excelforum.com/showthread...hreadid=558279 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel found unreadable content in 'stock.chart.object.xlsm' | Charts and Charting in Excel | |||
Replace object causes an error if search text not found | Excel Programming | |||
Option button object proeprties or object not found in vba | Excel Programming | |||
Workbook_Open | Excel Programming | |||
WScript object not found (???) | Excel Programming |