Hi,

There's no need for copying and pasting use

TextBox3.Value = TextBox1.Value

This line returns the active control name

Me.ActiveControl.Name

nd this retuns the value

Me.ActiveControl

Mike

"Alan" wrote:

I have a user form that contains a number of text boxes. I want to
copy the text from one box and paste it to another but to be able to
do that I need to be able to read in the name of the active text box.
How can I do that or is there an easier way to copy/paste?

Regards,