Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox Lists
Hi all,
Need some help. If a comboBox list is a set range from a worksheet, and as in my case it is a list of customer names. When selected it creates a new worksheet and pastes the selection into a cell. But if the customer is Not in the list, can i have the New customer added to the range somehow by code from the combobox value ? Corey.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox Lists
Hi Corey
Sure. If the entry is not in the list then the combobox'es ListIndex is -1. So if it's -1 then add the value to the list. HTH. Best wishes Harald "Corey" skrev i melding ... Hi all, Need some help. If a comboBox list is a set range from a worksheet, and as in my case it is a list of customer names. When selected it creates a new worksheet and pastes the selection into a cell. But if the customer is Not in the list, can i have the New customer added to the range somehow by code from the combobox value ? Corey.... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox Lists
Corey wrote:
/Hi all,/ // /Need some help./ // /If a comboBox list is a set range from a worksheet, and as in my case it is a list of customer names./ /When selected it creates a new worksheet and pastes the selection into a cell./ // /But if the customer is Not in the list, can i have the New customer added to the range somehow by code from the combobox value ?/ // /Corey..../ adding at the end. cbo.AddItem "value", cbo.ListCount if you have multicolumn combo you can fill out other columns with cbo.List(cbo.ListCount - 1, column) = "text" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Combobox options based on the input of another combobox | Excel Programming | |||
ComboBox list reliant on the entry from a different ComboBox | Excel Programming | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
Multiple ComboBox Lists | Excel Programming |