Combo box default value
 

When creating a combo box with the listfillrange originating from an external
spread sheet the combo box is blank when the spread sheet is opened. All of
the drop down options are there and the box functions properly including the
linked result cell which gives the last saved value except for the visible
reference.

How do I require that the combo box has text or a value visible from the
last saved position when opened?

Thank you,