While Greg's suggestion may do what you want, without knowing what the data is that you want to store in the userform it is difficult to suggest the best approach. You could for example populate the combo box from the code that calls the userform without the need for another document or table.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
|