Hello.
I have ComboBoxes (CB) on a userform that I use to select an item from a range of cells in the WorkSheet, this range is in the CB properties under RowSource e.g. "Sheet1!AK61:AK67".

As I want the selected item to be placed in a WorkSheet cell, I have put the following code in the UserForm Module.
Private Sub ComboBox11_Change()
Worksheets("Sheet1").Range("AG56").Value = ComboBox11.Text
End Sub
In the WorkSheet I copy this to other cells, but as I want to copy different data back to the cell and have it show in the ComboBox in the UserForm I have also marked the Properties of the ComboBox in the 'Control Source' as AG56
When the UserForm is opened up the comboBoxes (that are blank) i.e. no data in cell AG56

Everything works correctly except when I select the dropdown arrow on the ComboBox and click on an item for the first time, the ComboBox returns empty.
If I repeat the selection it appears in the ComboBox as wanted.

My question is, What have I got wrong? is it the event handler or something in the ComboBox properties that is having a conflict.

I would appreciate your thoughts on this immeasurably.