When I click the Add button on the form nothing is transferred from the first listbox to the second.

However the selected item seems to be removed from the first listbox and a row appears to be removed from the sheet.

So, I'm afraid I'm a little confused.

How can we replicate the behaviour you describe?