Win XP, Excel 2003

On my form there's a Combo Box with shows the first only of 7 optional
selections in the initial mode, and all 7 in the drop down mode.
When one (say the second entry) is selected, it does something and the
form's dismissed.
How can I arrange matters so that when the form is recalled,
it shows the last selected entry in the initial mode, rather than the first.
donwb