azizrasul
Well-known Member
- Joined
- Jul 7, 2003
- Messages
- 1,304
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
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.
Code:
Windows(strSchemeFilename).Activate
Load frmCompanyDetails
frmCompanyDetails.txtName = strCompanyName
Load frmQuoteDetails 'Errors here
frmQuoteDetails.txtDirectory = strPDFDir
frmQuoteDetails.txtDocName = "ABC"