Issue viewing “additional controls” for toolbox in VBE

255 pts.
Tags:
ActiveX Controls
Additional Controls
Excel 2003
library
References
Runtime Errors
Toolbox
VBA
VBE
I am unable to view the dialogue box when I select the "additional controls" option from the VBE menu bar, or when right clicking on the toolbox itself.  The project I created on one computer includes several forms, one of which includes a few DTPicker(s).  Some internal office issues have forced me to work on my project from a different computer...what do ya know...the code doesn't fully work!

The issue is the DTPicker control.  I have checked my references, and mscomct2.ocx is linked to the project.  The file exists in the system32 folder.  I've tried to code my project to programactically create the DTPicker(s) i need (using CreateObject("MSComCtl2.DTPicker")), but receive Runtime Error '429'.  I've also tried to find the controls I need using the "additional controls" opiton for the toolbox, but the dialogue box to choose which controls I wish to add to the toolbox does not appear.  I have checked a couple other systems in the office.  Some have this same issue, but on some the dialogue box appears just fine, and I am able to select whatever controls I need to use.

All the systems run Windows XP and Excel 2003, so I'm not sure why some work and some don't.

I'll continue to search the web for answers, but at this point I have NO idea what the issue is.  If I'm too vague or confusing...sorry I'm a bit confused myself :)

Please HELP!!!



Software/Hardware used:
Excel 2003
ASKED: September 17, 2009  5:48 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following