Ok then the question becomes how do i reference the typed text inside
combobox so that i can copy it to a cell on the data worksheet?



Dale Preuss Wrote:
When you enter text into a combobox that allows data entry, the lis
index of
the combobox is set to -1. During the process of doing whatever you
form is
doing, if the list index is -1, the text in the combo box must be adde
to
the list fill range on the other worksheet. The range must also b
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 anothe
sheet
in the same workbook.

The problem i have is that when the customer name is not already i
the
datasheet that i use for the listfillrange and i go ahead an
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 sav
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 dat
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



--
john q publi
-----------------------------------------------------------------------
john q public's Profile: http://www.excelforum.com/member.php...fo&userid=1578
View this thread: http://www.excelforum.com/showthread.php?threadid=27294