Populating a word VBA combo box from excel

**laralara** · 08-31-2010, 11:59 PM

Hi All,

Basically i have a list in excel with customer addresses.
I want to be able to keep this as the 'master database' and have a combo box in a template userform refer to it.
That way the combo box will be updated if there is a change in the database.

Can someone please let me know if this is possible.
And some basic directions.

Much appreciated.
Lara

**snb** · 09-24-2010, 08:29 AM

You have a userform in the Worddocument: Userform1
The userform conains 1 combobox: Combobox1
The name of the Excel file is: E:\Excel\adres.xls

Put this code in the Userform module

Code:

Private Sub UserForm_Initialize()
  With GetObject("E:\Excel\adres.xls")
    Combobox1.List = .sheets(1).usedrange.Value
    .Close False
  End With
End Sub

Start the userform : Userform1.show

That's about all.

Thread: Populating a word VBA combo box from excel

Thread Tools

Rate This Thread

Display

Populating a word VBA combo box from excel

Re: Populating a word VBA combo box from excel

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions