I'm trying to populate a combo box on my worksheet with a row of data, however all it will do is display the first row. ie. A.

Also, the user enters data into another worksheet which in turn populates the table. I would therefore like the combo box to show the last entry entered by the user without the user having to scroll through to search for it.

Is this possible?

Thanks