VBA code to open a user form if the user form is located in an addin?

New to VBA here. As I understand it from what I've read elsewhere, there are two methods to do this:

1. Add the addin project in Tools > references and then open the form with UserForm1.show

2. Use Application.Run "FileName.xlam!Sub"

I can't get either of these to work! Any help greatly appreciated.

Thanks

Your syntax looks incorrect and is missing a set of single quotes. Try this.

Please Login or Register  to view this content.

Thanks very much for your reply! I've changed it to the following:

Application.Run "'EC_List_Search.xlam'!UserForm_Initialize"

and still get the error: "Application defined or object-defined error"

I read something about putting code in a module of the workbook that you're trying to open it from the link below but also can't get this working:

mrexcel.com/board/threads/display-userform-that-exists-in-add-in.47977/

Is it that I need to declare it as an object in the workbook I'm trying to open it from?

It may be time for you to share some code as it could be something in your actual code causing the error. My guess is that you are trying to load the form in the script being used in your non-addin file.
In your addin file, you should have both

1. Your userform
2. A script to call the userform in a standard module.

Please Login or Register  to view this content.

And you can call and load your userform from another file by calling that script.

Please Login or Register  to view this content.