Can I just thank you guys for your input and for your time, you have
helped me enormously - Dave has supplied the magic solution - why
didn't I think of that?

Thanks again,

Alan

On 2 Jan, 16:08, Dave Peterson wrote:
You could select the text and hit ctrl-c, then select the other textbox and hit
ctrl-v to paste.

No VBA required.