I have a user form that has three diffferent drop boxes, as well as multiple
check boxes on it. I have altered the way that I load the combo boxes
numerous times to make sure that they load correctly, such as:

Combobox1.rowsource = ShtLists.range("List1).values
Combobox1.RowSource =
ThisWorkbook.Sheets("TheLists").Range("g3:g4").Add ress(external:=True)

The problem is that even when they appear to load and operate correctly if,
(once I am back on the Excel page) if I close the file without saving Excel
aborts. This only happens if I have opened the user form and selected one of
the combo boxes.

I have named ranges that contain these lists and have named the sheets as
well, such that the list I want to load in ComboBox1 is really on sheet
"ShtLists" in range "List1", so usually I would reference as
shtlists.range("List1"). I have reverted back to Sheet Names and cell
references to try and eliminate any of the object problems I have read about.

I really need to know the cleanest way to load these drop boxes and if I
need to clean them out before closing the form.

Thank you in advance for any help.