Why not just reload the combobox with the value in the
cell that corresponds to it?

UserForm1.ComboBox1.Value = Sheets("Sheet1").[A1].Value

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a userform with several combo boxes so that the
user can select
certain features. Upon clicking the "OK" button, the
values are then
inserted into the appropriate ranges on the spreadsheet.

Is there a way that the values selected in the combo
boxes can be
retained after the userform is either hidden or
dismissed. I would like
the last values selected in case the user changes his
mind and would
like to edit one or two selections without having to re-
select all of
them. I tried just hiding the userform, but that did not
work.

Thanks,

Greg

.