Fill a combobox from a worksheet

[elsteshepard]

Hi,

I have done some basic userforms in word and excel, and I mean basic!

I was wondering if it is possible to populate/fill a combobox on a userform from an excel document - either a named range or just a cell range?

I don't want to have to manually enter all the options - also, the list changes on a weekly basis, which would be a major pain. It would be much better to use the 'master' which is an excel spreadsheet.

Possible?

Thanks

[lucas]

Attached is a small example. Extract the word and excel file to the same directory and run the word file: