Excel Form Drop Down doesn't retain value

Hi folks,

I need to use a Form control - a drop down, not the ActiveX combobox. I load the drop down using AddItem, make a selection from the list, save and close excel, and reopen execl. The chosen value is not there, but the list items are remembered (despite me not re-initializing the list upon opening the book). I just need whatever item the user last selected after he saved the book to remein selected upon open.

Is that possible with the Drop Down Form control?

Thanks a lot.

I'm trying to populate the Form drop down with the following, but nothing is showing up:

With Worksheets("plots")
lastcol = Worksheets("data").Range("A4").End(xlToRight).Column
With Worksheets("data")
Set SourceRng = .Range(.Cells(4, 1), .Cells(4, lastcol))
End With
comboArray = WorksheetFunction.Transpose(SourceRng)
.Shapes("Drop Down 64").ControlFormat.InputRange comboArray.Value
End With

Oh, forgot an = sign:

Worksheets("plots").Shapes("Drop Down 64").ControlFormat.List = comboArray

Then it works.