select the cell, go to the formula bar, highlight the data, do ctrl+c

select the textbox by clicking in the textbox, do Ctrl+v

this always works for me.

--
Regards,
Tom Ogilvy

"Al" wrote in message
om...
I need a user to be able to copy the contents of a worksheet cell,
open a usrform and paste those contents into a textbox - I can't seem
to do it. The cell contents are copied OK (CTRL-C to the clipboard)
but when the textbox is selected and CTRL-V used, nothing happens. I
don't see any relevant properties for the textbox relating to this
functionality - can anyone help?

Thanks,
Al