Error 424 - Object Required

[azizrasul]

In my VBA code I open another workbook (call it Book2.xlsm) which has several user forms. The code allows the first form to open but get an error (Error 424 - Object Required) when the second user form is being opened. Both user forms open OK in Book2.xlsm.

    Windows(strSchemeFilename).Activate
    Load frmCompanyDetails
    frmCompanyDetails.txtName = strCompanyName
    Load frmQuoteDetails 'Errors here
    frmQuoteDetails.txtDirectory = strPDFDir
    frmQuoteDetails.txtDocName = "ABC"

 

[Vbagreenhorn1]

I guess there must be something in the Userform_Initialize event that cant be found.

 

[azizrasul]

I eliminated that by commenting all the Initialize code, but no luck.
The form opens OK in it's host workbook.
Tried swapping forms around so that the code calls the rogue form first, still no luck.
Tried opening a third user form, same error. Seems to only like user form "frmCompanyDetails".

 

[azizrasul]

All the forms use the Activate event instead of the Initialize event.

 

[Fluff]

In the VBE select Tools > Options > General > select Break in Class Module > OK.
Then try running the code again & it should hopefully show where the problem is.

 

[Norie]

Which workbook is the code in and which workbook is the userform that's causing the problem in?

 

[azizrasul]

Just had a brainstorming session with a colleague and we realised that the reason why frmCompanyDetails was 'working' was that the calling wb had a form of the same name. So in essence it wasn't even loading frmCompanyDetails of the other wb.
I guess I need to have a macro in the other wb and somehow pass the values from the calling wb to the forms.