selected value is not saved in combo box

  • Thread starter Thread starter MarkDev
  • Start date Start date
M

MarkDev

I have problem with saving a combo box selected values in excel file.
I've created a simple excel file using Office 2003. I've added a
combo-box to one of worksheets. After I am selecting any value in the
combo-box, saving the excel file and closing it. After opening the
file there is no value selected in the combo-box.
What I need to do in order to be able to keep selected values in the
combo-box after closing and opening the excel file.

Thanks in advance!
 
I added a combobox from the control toolbox toolbar to a worksheet.

I also assigned a linked cell to the combobox and it all worked ok--the linked
cell's value gets saved when the workbook saves.
 
Back
Top