Instantiate controls and forms in an Add-in
 

I want to create an Add-in that automatically runs in the workbook when
I install it and then creates a command button in "A1". When that
button was clicked it will create a form with treeview and
listview....I can't find any tips and articles about that..is it
possible? please help me...thanks in advance

Instantiate controls and forms in an Add-in
 

You have 3 questions:

How do I create an Add-In?
How do I create a command button in A1?
How do I write a macro that will create a form with treeview and listview?

Do you need help with all of the above or just one?

"Dantz" wrote:

I want to create an Add-in that automatically runs in the workbook when
I install it and then creates a command button in "A1". When that
button was clicked it will create a form with treeview and
listview....I can't find any tips and articles about that..is it
possible? please help me...thanks in advance

Instantiate controls and forms in an Add-in
 

Dantz,

Is your addin a developer tool, or are you just interested in dynamic
forms.

Dm Unseen

Instantiate controls and forms in an Add-in
 

Dm Unseen,

it is a developer tool and im also interested in dynamic forms because
it will help me a lot.

Dantz

Instantiate controls and forms in an Add-in
 

Dynamic forms can be created by first creating a form in design view
and the adding controls at run time. using the controls.add method.
Note that those controls will not be persistent in the design view.

To add forms and controls to the actual (persistent) design you need to
use the VBA IDE (VBIDE) extensebility library. This is more tricky and
less examples for this exist. see
http://groups.google.nl/group/micros...e2630 49debb2

good books programming the VBA IDE are Excel VBA programmers
reference(John Green et al) from wrox, and VBA power programming from
John Walkenbach.

DM Unseen