Edit worksheet data thru userform

Sorry royUK, there is no difference between your code's result and mine,

The problem is still existing .. the changes are still recorded in the first record.

Anyhow, I found a solution but it is not that much practical.

My trick solution is saving combobox value in a label (the label will be hidden), and the use the label value as a database search key,

See my attachment.

Thank you,