Is it possible to automatically update a combobox whenever a new item is added in a range in excel?
Thanx in advance,
Greyskull:wave:
Printable View
Is it possible to automatically update a combobox whenever a new item is added in a range in excel?
Thanx in advance,
Greyskull:wave:
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.