OFF98: How to Display a ComboBox List When the UserForm Is Displayed (182340)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
- Microsoft Word 98 Macintosh Edition
- Microsoft PowerPoint 98 Macintosh Edition
- Microsoft Visual Basic for Applications 5.0
This article was previously published under Q182340 SUMMARY
In the programs listed at the beginning of this article, you can display
the list for a ComboBox control when the UserForm is displayed by using the
Activate event for the UserForm in Microsoft Visual Basic for Applications.
This article includes a sample Sub procedure that uses the DropDown method
of a ComboBox and the Activate method of a UserForm to automatically
display the list of a ComboBox control when a UserForm is displayed.
REFERENCES
For more information about using the DropDown method, click the Office
Assistant in the Visual Basic Editor, type dropdown, click Search, and then click to view the "DropDown
Method" topic.
For more information about using the Activate event, click the Office
Assistant in the Visual Basic Editor, type activate, deactivate, click Search, and then click to view the "Activate,
Deactivate Events" topic.
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Excel Help is not installed on your
computer, please see the following article in the Microsoft Knowledge Base:
179216 How to Use the Microsoft Office Installer Program
Modification Type: | Major | Last Reviewed: | 6/23/2005 |
---|
Keywords: | kbhowto kbProgramming KB182340 |
---|
|