Results 1 to 2 of 2
2008-04-24, 21:22 #1
- Join Date
- May 2001
- Omaha, NE USA, Nebraska, USA
- Thanked 0 Times in 0 Posts
DialogSheets, adding controls (Excel 2007 SP1 MSO)
I am in the process of reviewing all of my add-ins and macros to move them from Excel XP to Excel 2007. I came across this section of code that gives me a run-time error (the code that is highlighted is what is marked when I debug the run-time error). Any ideas on what is causing the problem and how to resolve it. This is a snippet of code in a procedure that will create a dialog sheet that lists all of the worksheeets in the workbook and allows the user to select which worksheets should be printed.
<pre> ' Add text field to control number of copies to print
TopPos = TopPos + 5
PrintDlg.EditBoxes.Add 82, TopPos, 15, 18
<span style="background-color: #FFFF00; color: #000000; font-weight: bold">PrintDlg.TextBoxes.Add 100, TopPos, 90, 18</span hi>
TopPos = TopPos + 25
PrintDlg.EditBoxes(1).Text = 1
PrintDlg.TextBoxes(1).Text = "How many copies?"
The RunTime Error message box reads; "Run Time Error '1004'; Add method of TextBoxes class failed"
2008-04-24, 23:47 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: DialogSheets, adding controls (Excel 2007 SP1 MSO)
Dialog sheets were deprecated in favor of userforms in Excel 95, some 13 years ago. They have been supported in later versions for compatibility reasons, but I think it's time to discard them, and create userforms instead.