BUG: Event handlers that are associated with a ListObject control stop responding on an Office Excel worksheet that is hosted in Visual Studio 2005 (908422)


The information in this article applies to:

  • Microsoft Visual Studio 2005 Tools for the Microsoft Office System
  • Microsoft Office Excel 2003

SYMPTOMS

Consider the following scenario. You add or delete columns or rows from a non-databound ListObject control in a Microsoft Office Excel worksheet. Then you use the Undo List Resize command.

Note The Office Excel worksheet is hosted in Microsoft Visual Studio 2005 at run time.

In this scenario, event handlers that are associated with the ListObject control stop responding (hang).

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

Steps to reproduce the problem

  1. Start Visual Studio 2005.
  2. On the File menu, click New, and then click Project.
  3. In the New Project dialog box, click Office, and then click Excel Workbook.
  4. Type a name in the Name box, and then click OK.

    Office Excel is now hosted on Visual Studio 2005.
  5. In the Toolbox, click Excel Controls, and then add a ListObject control to Sheet1.

    A list that contains one column and no data is created on Sheet1.
  6. Double-click the list that you created in step 5 to open the Sheet1 code window.
  7. Add the following code to the list1_Change event handler:
    MessageBox.Show("ListChange")
  8. On the Debug menu, click Start Debugging to build and run the project.
  9. In the new Office Excel workbook, add an item to the list by typing some text in cell A1, and then press ENTER.

    Notice that the ListChange message box appears.
  10. Resize the list by dragging the lower-right corner of the list one column to the right.

    The ListChange message box appears when you finish dragging.
  11. On the Edit menu, click Undo ListResize.

    Notice that the ListChange message box does not appear.
  12. Add an item to the list by typing some text in cell A2, and then press ENTER.

    The ListChange message box again does not appear, and handlers that are associated with the ListObject control stop responding.
Modification Type:MajorLast Reviewed:12/7/2005
Keywords:kbpending kbtshoot kbbug KB908422 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.