call addin's userform

Hot Topic

Application.File Search.
Using Tabs in MSComctlLib.TreeCtrl.2 control
Range
Edit Record Error
Can't open regedit
Batchs of Subs ! But How ??
How to declare activeX object in source code instead on the form?
Highlighting cells within a worksheet
Help with comma separated values in report
Internet access, XML in VBA, extra modules

Microsoft ISV

Library Reference issues.
sending emails from MS Word with variable subject line
How To Open A File On Another Computer On A Home Network
Excel Time Help
Recursive Function
document title
Saving information in a form
opc
How to allow cookies for Windows Live ID
Sort rows within a range

call addin's userform

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




Answer this question

call addin's userform

  • Elroacho

    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.



  • call addin's userform
Answer this question