selected value is not saved in combo box

[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!

 

[Guest]

The data needs to be stored in a cell in order to be saved. Open up the
Properties of your Combo Box. You should see a field called "Linked Cell".
This cell is where the data will be stored.

Typically, I'll create a seperate sheet for data storage, then hide that
sheet. That way, I've got a nice central location to store all data from
other worksheets, that doesn't get in the way.

HTH,
Elkar

 

[MarkDev]

thank you so much!