ComboBox control
Combines the features of a ListBox and a TextBox. The user can enter a new value, as with a TextBox, or the user can select an existing value, as with a ListBox.
Remarks
If a ComboBox is bound to a data source, the ComboBox inserts the value the user enters or selects into that data source. If a multi-column combo box is bound, the BoundColumn property determines which value is stored in the bound data source.
The list in a ComboBox consists of rows of data. Each row can have one or more columns, which can appear with or without headings. Some applications don't support column headings, others provide only limited support.
The default property of a ComboBox is the Value property. The default event of a ComboBox is the Change event.
Note
If you want more than a single line of the list to appear at all times, you might want to use a ListBox instead of a ComboBox. If you want to use a ComboBox and limit values to those in the list, you can set the Style property of the ComboBox so the control looks like a drop-down list box.
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기