Add-In...form call

[Guest]

I got a great information about add-ins from thi forum.....a little thing i m stuck with....hope someone will help me out here.

I have an add-in ...which has some modules and a form. I need to call the form in my other excel templates ....could someone sugest me the code to call the form in xla

Thanks

 

[Chip Pearson]

Ajit,

In the add-in, create a public function like

Public Sub ShowTheForm()
UserForm1.Show
End Sub

and then use Application.Run to execute that macro:

Application.Run "MyXla.xla!ShowTheForm"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

I got a great information about add-ins from thi forum.....a

little thing i m stuck with....hope someone will help me out
here.

I have an add-in ...which has some modules and a form. I need

to call the form in my other excel templates ....could someone
sugest me the code to call the form in xla .