Add-In...form call

A

Ajit

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
 
C

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


Ajit said:
I got a great information about add-ins from thi forum.....a
Click to expand...
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
Click to expand...
to call the form in my other excel templates ....could someone
sugest me the code to call the form in xla .
 
Top