You can break the rowsource / controlsource links and populate your combobox
using code

Private Sub Userform_Initialize()
With Worksheets("Data")
set rng = .Range(.cells(1,1),.Cells(1,1).End(xldown))
End With
me.Combobox1.List = rng.Value
End Sub

Private Sub Combobox1_Click()
worksheets("Data").Range("B9").Value = _
me.Combobox1.Value
End Sub

--
Regards,
Tom Ogilvy

"MDW" wrote in message
...
Hey all,

I've got a minor issue with a workbook. I've got a userform with a
combobox
that gets its content from a range on the worksheet. It's a static range;
no
one else uses the workbook but me and I don't need to change the content.

Every time I try to close this sheet, I get a pop-up that says "Would you
like the save the changes you made in ...?" I can only assume that the
"changes" are due to the fact that the combo box is being dynamically
populated every time I open the form.

Is there anything I can do to stop this from happning? Ideally, if there's
a
way to simply hard-code the options into the combo box like you can do in
Access, I'll take it.
--
Hmm...they have the Internet on COMPUTERS now!