ComboBox - Link Cell that Accumulates

[Guest]

Hello,

I want to create a combo box that accumulates the chosen options from the
dropdown list into the linked cell. In other words, the destination cell
needs to keep as many options as the user chooses from the drop down (with
out deleting its contents). example:

- Link filled list: option1, option2, option 3
- The user chose option1 & option2
- The destination cell in the combo box should display: option1 option2.

Can this be done?

Thanks,

 

[krcowen]

EddieV

I don't think you can do it by simply using the linked cell property;
but, you can do it with a simple line of code. In the combobox_change
event just put:

Private Sub ComboBox1_Change()
Cells(1, 1).Value = Cells(1, 1).Value & ComboBox1.Value
End Sub

where Cells(1,1) is replaced by the cell row and column to which you
want to append any combobox selections.

Good luck.

Ken
Norfolk, Va.