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!

[Elkar]

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" wrote:

>
> 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!
>
>
> --
> MarkDev
> ------------------------------------------------------------------------
> MarkDev's Profile: http://www.excelforum.com/member.php...o&userid=35572
> View this thread: http://www.excelforum.com/showthread...hreadid=553776
>
>

[MarkDev]

thank you so much!