Hi there
I just noticed that copying a worksheet does not preserve the state of the combo boxes within. Please have a look at the attached excel sheet and code.
I open a workbook containing a combobox whose selected index is 4.
The values from the combo box and the linked cell are are:
Original Values ->
SelectedIndex: 4
SelectedValue: Choice 5
SelectedCell.StringValue: Choice 5
linkedCell.StringValue: 5
If I copy the worksheet, the values I get are:
Copied Values ->
SelectedIndex: -1
SelectedValue: 'empty'
SelectedCell.StringValue: 'null'
linkedCell.StringValue: 5
You'll notice that the state of the linked cell gets copied correctly but the state of the combo box is not.
Cheers
Lukas