Microsoft Office Tutorials and References
In Depth Information
Filling a Word Combo Box with Data from Excel
Filling a Word Combo Box with Data from Excel
by Cindy Meister
This macro expands on the Entering Data Easily Using a Custom Dialog Box
procedure found on page 254 by using an Excel workbook to fill the combo box
from which data can be selected to go into the State field.
Example file:
W037
Scenario: When entries should be limited to a certain
selection, it is often easier to present them to the user in a
list or drop-down. This is often a time-saver for the user, as
well.
This tool builds on the example presented in the previously noted entry. The
text box for the State information has been replaced with a drop-down list. The
values to fill the list come from an Excel workbook.
Cmb
Figure 100 – Choosing Data from Excel
 
Search JabSto ::




Custom Search