Where does the "text" that populates the combo box come from? Is it from a database or another text file?
AndreRet
Senior Poster
3,922 posts since Jan 2008
Reputation Points: 334
Solved Threads: 350
You can add the following code directly to the Document_Open event or you can add it in a stand alone module and call the sub when the document opens.
With ActiveDocument.ComboBox1
.Clear
.AddItem "January"
.AddItem "February"
.AddItem "March" 'And so on......
End With
You can also try the following under the UserForm_Initialize event -
Me.ComboBox1.List = Split("January|February|March") 'And so on...
AndreRet
Senior Poster
3,922 posts since Jan 2008
Reputation Points: 334
Solved Threads: 350
It was a pleasure.:) Happy coding.
AndreRet
Senior Poster
3,922 posts since Jan 2008
Reputation Points: 334
Solved Threads: 350