Replied 27 December 2020, 6:12 pm EST
You can achieve this in two ways. First using the StartEdit event and second using the ComboDropDown event.
1: Instead of using ComboDropDown, you need to use StartEdit, since the StartEdit fires before the cell enters edit mode, the changes made to the combo list will be shown in the Combobox. It doesn’t refresh the items if you set the ComboList in combodropdown since the Combobox has already been created and items already added. If you use this method then once the user enters edit mode and opens the Combobox dropdown multiple times while staying in edit mode, the items will stay the same.
2: If you want to update the items every time the dropdown opens then you can use the ComboDropDown event and add the items manually to the Combobox. Please refer to the samples attached.