?
Solved

How do I find the UpDown control in Excel 2007

Posted on 2008-02-06
4
Medium Priority
?
318 Views
Last Modified: 2013-12-26
I created an Excell application using Excel 2003 and Visual Basic 6. The application uses an UpDown control to move items in a list box. When I open the application in Excel 2007 I get the error message above. When I click on a button that opens a form the initialization routine attempts to set the visibilty of the UpDown control to false, and I get a run-time error: "Variable not defined," which identifies the line "btnUpDown.Visible = False." Upon further examination the UpDown control is missing from the form and it does not exist in the Controls Toolbox. I found this to be true on all the Excel 2007 instalations in my office.

How do I add this cotrol to Excel 2007?
0
Comment
Question by:rmil7890
  • 2
  • 2
4 Comments
 
LVL 38

Accepted Solution

by:
jeverist earned 2000 total points
ID: 20835959
Hi rmil7890,

The control (v6) works fine on my installation and is also available from the Controls Toolbox (via right-click, Additional Controls...).  Look for the 'MSCOMCT2.OCX' control library on your systems.  You may need to register it from Start>Run>:

regsvr32 /v "C:\Windows\system32\MSCOMCT2.OCX"

Jim
0
 

Author Comment

by:rmil7890
ID: 20836682
Thanks very much Jim. The file mscomct2.ocx was missing on the test machine. I copied it from my dev machine and registered it, and now the application works.

Ron
0
 

Author Closing Comment

by:rmil7890
ID: 31428612
Thanks, Jim.
0
 
LVL 38

Expert Comment

by:jeverist
ID: 20845046
Ron,

You're welcome and thanks for the grade!

Jim
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

599 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question