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 ->
SelectedValue: Choice 5
SelectedCell.StringValue: Choice 5
If I copy the worksheet, the values I get are:
Copied Values ->
You'll notice that the state of the linked cell gets copied correctly but the state of the combo box is not.