Where is the Treeview Control in Excel 2003?

C

cr113

Where can I get the Treeview Control for Excel 2003? Do I need to add
a reference?
 
R

RB Smissaert

Yes, need to set a reference to C:\Windows\System32\MSCOMCTL.ocx
to get the Microsoft TreeView Control 6.0 (SP6).

RBS
 
C

cr113

- Show quoted text -

Yes, need to set a reference to C:\Windows\System32\MSCOMCTL.ocx
to get the Microsoft TreeView Control 6.0 (SP6).

OK, I set a reference to MSCOMCTL.ocx but none of those additional
controls show up in my Toolbox. How do I drop the Treeview object onto
my form?

Thanks!
 
R

RB Smissaert

Load your control toolbox in the VBE, right-click on an empty bit of the
toolbox and
do Additional Controls. Then tick that treeview control as mentioned.

RBS

- Show quoted text -

Yes, need to set a reference to C:\Windows\System32\MSCOMCTL.ocx
to get the Microsoft TreeView Control 6.0 (SP6).

OK, I set a reference to MSCOMCTL.ocx but none of those additional
controls show up in my Toolbox. How do I drop the Treeview object onto
my form?

Thanks!
 
C

cr113

Load your control toolbox in the VBE, right-click on an empty bit of the
toolbox and
do Additional Controls. Then tick that treeview control as mentioned.

Success!!!

Thank you very much!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top