Microsoft KB Archive/160266

= XL97: UserForm ListBox Is Blank When Run from a Binder Section =

Article ID: 160266

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q160266



SYMPTOMS
When you run a Visual Basic for Applications UserForm that contains a ListBox, and you are running the UserForm from a Microsoft Office Binder section, the ListBox appears to be blank.



CAUSE
This behavior occurs if the ListBox on the UserForm is linked to the worksheet. When you open the link in the Office Binder section, the link is not updated.

NOTE: If you open the file in Microsoft Excel, the UserForm ListBox is populated. A ListBox you create on worksheets using the Forms tools (instead of UserForms) is populated in both Microsoft Excel and in a Binder section.



STATUS
Microsoft has confirmed this to be a problem in the products listed at the beginning of this article.

