Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editable, Linked Combobox.
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editable, Linked Combobox.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make Excel linked to SQL Server 2005 worksheet editable? | Excel Discussion (Misc queries) | |||
ComboBox linked to TextBox | Excel Discussion (Misc queries) | |||
Editable Combobox? | Excel Programming | |||
Non-Editable ComboBox? | Excel Programming | |||
ComboBox with an editable function | Excel Programming |