Combobox delets text typed in on open of saved file.

[Guest]

I have a combobox that is linked and bound to other cells. I can select
words from the list just fine and it saves them and displays them when i
reopen the document. The problem is when the name i am looking for is not on
the list and i have to type it in manually. When i do this it lets me type
the name and i can print the sheet and the name is there and i can click the
save button and the name is there. When i open the saved sheet however the
name will apear for a quick second then the workbook finishes loading and the
name disappears.

Any advice on how to get the name to save in the combobox and be there when
i open it would be greatly appreciated.

 

[Dave Peterson]

When your workbook opens:

Do you have any code that touches that combobox?
Do you have any code that touches that linkedcell?

I put a combobox from the control toolbox toolbar on a worksheet and used A1:A10
for the listfillrange and B1 for the linkedcell.

I typed into the combobox and the linkedcell was updated.

I saved and closed and it worked ok.