Focus Method Doesn't Set Focus to Correct Dialog Control

WORKAROUND

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. To work around this behavior in Microsoft Excel for the Macintosh, use the Focus method to set the focus to an edit box in the dialog box, and assign the procedure that contains the Focus method to the dialog frame.

To work around this behavior in Microsoft Excel for Windows, assign the procedure that contains the Focus method to the dialog frame. The following is an example of how to set the focus in a custom dialog box using the Focus method in Microsoft Excel for either platform:

Example

1. Create a custom dialog box that contains two edit boxes, and a combination drop-down edit control.
2. In the dialog box, select the drop-down control, and note the name that appears in the Name box, such as "Drop Down 5."
3. From the Insert menu, choose Macro, and then choose Module. In the new module, enter the following:

         Sub Main()
            DialogSheets(1).Show
         End Sub
   
         Sub DialogFrame1_Show()
            ' Note that the name used with the DropDowns method should
            ' be the name noted in Step 5 above.
            ActiveDialog.Focus = _
                 DialogSheets(1).DropDowns("Drop Down 5").Name
         End Sub
   						

4. Select the Dialog1 sheet tab, and select the dialog title. From the Tools menu, choose Assign Macro. From the Macro Name/Reference list, select DialogFrame1_Show, and choose OK.
5. From the Tools menu, choose Macro. From the Macro Name/Reference list, select Main, and choose Run.
   
   Note that the drop-down edit box has the focus.