call addin's userform  
Author Message
Nrupesh





PostPosted: Visual Basic for Applications (VBA), call addin's userform Top

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




Microsoft ISV Community Center Forums3  
 
 
Derek Smyth





PostPosted: Visual Basic for Applications (VBA), call addin's userform Top

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.