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

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


"Ajit" wrote in message
...
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