Import UserForms using VBA Code

[xlhelp15]

Hello Experts,

Is there a way to import UserForms (located in separate folder) when I open Excel file ?

Workbook_Open method can help but I'm not sure as how to call the Forms from that.

Your help is greatly appreciated !

Thanks.

 

[Domenic]

To import a userform, you can use the Import method of the VBComponents object. Note that you'll need to allow access to the VBA project...

File >> Options >> Trust Center >> Trust Center Settings >> Macro Settings >> Developer Macro Settings >> check/select Trust access to the VBA project object model

Here's an example...

    Dim path As String
    Dim fileName As String
    
    path = "c:\users\domenic\desktop\"
    
    fileName = "userform1.frm"
    
    ThisWorkbook.VBProject.VBComponents.Import path & fileName

 

[James006]

@ Domenic

If I recall correctly ... from Chip Pearson lessons ...

there is a need to include a check in Tools > References > Microsoft Visual Basic for Applications Extensibility ...

Right or Wrong ?

 

[Domenic]

@ Domenic

If I recall correctly ... from Chip Pearson lessons ...

there is a need to include a check in Tools > References > Microsoft Visual Basic for Applications Extensibility ...

Right or Wrong ?

You need to set a reference when using early binding. In my example, since I'm using late binding, no reference is needed.

 

[James006]

You need to set a reference when using early binding. In my example, since I'm using late binding, no reference is needed.

Thanks for the info ...

 

[Domenic]

Thanks for the info ...

You're very welcome!

Cheers!

 

[xlhelp15]

To import a userform, you can use the Import method of the VBComponents object. Note that you'll need to allow access to the VBA project...

File >> Options >> Trust Center >> Trust Center Settings >> Macro Settings >> Developer Macro Settings >> check/select Trust access to the VBA project object model

Here's an example...

    Dim path As String
    Dim fileName As String
    
    path = "c:\users\domenic\desktop\"
    
    fileName = "userform1.frm"
    
    ThisWorkbook.VBProject.VBComponents.Import path & fileName

Awesome ! - Thanks much Expert !