The second block of code goes in the userform. The rest goes in an ordinary module.

Don't forget the ExcelFillList function from my web site. That goes in a separate ordinary module.

It will work with a list box or a combobox. The list box doesn't use the prompt text. However as you are only selecting one item from the list, the combobox would probably make more sense.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com