When you enter text into a combobox that allows data entry, the list index of
the combobox is set to -1. During the process of doing whatever your form is
doing, if the list index is -1, the text in the combo box must be added to
the list fill range on the other worksheet. The range must also be adjusted
to allow the extra record. Obviously, the file must be saved, too.

Dale Preuss



"john q public" wrote:


Hi i have a combobox that is using the listfillrange from another sheet
in the same workbook.

The problem i have is that when the customer name is not already in the
datasheet that i use for the listfillrange and i go ahead and manualy
type their name in the combobox and then save the document. When i
reopen the document it deletes the name i typed in. It will save the
name and display it if i selected it from the drop down but not if i
type it in manualy.

Anyone have any suggestions as to how i can get it to keep the data in
there so when i re-open the workbook it does not disappear?


--
john q public
------------------------------------------------------------------------
john q public's Profile: http://www.excelforum.com/member.php...o&userid=15782
View this thread: http://www.excelforum.com/showthread...hreadid=272944