pebcak
05-08-2022, 05:59 PM
I've created a Userform programmatically (I know ... a lot of work, but I have my reasons). Excel trusts access to VBA project object model, and the Microsoft Visual Basic for Applications Extensibility 5.3 reference is selected.
Dim ufPld As VBComponent
Set ufPld = wbDB.VBProject.VBComponents.Add(3)
The form comes out great - the code loops through the data source, places all the controls in the right spots, fills in all of the captions properly... except I can't display it! The form is created and exists within the project but
ufPld.Show
throws an "Object doesn't support this property or method" error.
Please help? :(
Dim ufPld As VBComponent
Set ufPld = wbDB.VBProject.VBComponents.Add(3)
The form comes out great - the code loops through the data source, places all the controls in the right spots, fills in all of the captions properly... except I can't display it! The form is created and exists within the project but
ufPld.Show
throws an "Object doesn't support this property or method" error.
Please help? :(