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.