Hi,
In Excel, I wish to copy the contents of a textbox into a single cell.
How do I achieve this? The problem is the code to select the contents of the textbox.

The aim is to allow a user to type comments, which are then saved into a cell for later retrieval and the textbox is emptied so the next user can add comments.

Thanks, Simon