No, that won't work.
I already have a UserForm with VBA-code taking care of all input for the
calculation.
The calculation "document" is only the printout and eventually a saved
calculation line as well (for later retrieval). For these purposes I need a
customer reference.

"Jim Rech" wrote:

It looks to me that some macro work would be required to add new records to
your database. The built-in functionality/integration of the combobox with
a worksheet seems to be pretty limited. For my money better way to go is to
try to use the built-in Data, Form feature, or for something even better
look at this from John Walkenbach:

http://www.j-walk.com/ss/dataform/index.htm

--
Jim
"Mats Samson" wrote in message
...
| Hi,
| I have a ComboBoxes linked (RowSource) to a small database with customer
| names and addresses. (It's convenient to have contact and address
information
| filled into the calculation document.) But sometimes I want the customer
| reference for an unregistred customer in my calculation and be able to
write
| his name in the ComboBox and it appears in my calculation document.
| (The other addressfields can be omitted, I just need the customers name
for
| future reference).
| Can it be done? I.e. to have the controlsource accept other values than
the
| rowsource list?
| Best regards
| Mats