How do I find the UpDown control in Excel 2007
Posted on 2008-02-06
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?