ComboBox

[Greyskull]

Is it possible to automatically update a combobox whenever a new item is added in a range in excel?

Thanx in advance,

Greyskull:wave:

[TheFIDDLER]

You can use the Sub Workbook_SheetSelectionChange event to respond to changes done on a worksheet. Your code could look at where the data was entered, and if in a given range, add the item to your combobox.