Editable, Linked Combobox.

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

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" <MatsSamson@discussions.microsoft.com> wrote in message
news:88BF12BA-DF01-43CD-9072-6F6DA5C7CA57@microsoft.com...
| 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

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" <MatsSamson@discussions.microsoft.com> wrote in message
> news:88BF12BA-DF01-43CD-9072-6F6DA5C7CA57@microsoft.com...
> | 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
>
>
>