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!
 
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
 
Back
Top