I have creadted a .xla file, it have a userform in it.

i have loaded the xla addin.

now in my new spreadsheet, through vba maros can i display the userform which is in that .xla file

any help or ideas on how can i achive such a thing would be appreciated

nrupesh

hi there,

create a public method in your addin that displays the user form. You can then call this method using...

Application.Run ("myAddin.xla!ShowForm")

It's important that a) you check that the add in has been installed and b) that your addin does not have any spaces in it's filename, otherwise the Run() method won't be able to find it.

Use the Addins("myAddin").Installed = True to determine if the Addin has been installed

Hopefully that will help.