I programatically add a ComboBox shape to an Excel sheet. If it already exists, I just reference it.
When I now set the the selected index by using the SelectedIndex property, the changes get reflected in the object. However, the content of the linked cell is not updated and what's worse, if I save the file and open it using Excel, there is no selection made in the ComboBox.
workbook.CalculateFormula() does not help. Is there another method to force an update and propagate it to the Excel sheet?
Please refer to the attached files for a code example.
Many thanks and kindest regards