Textboxes – copy text from one to another.

[Mollethewizard]

First let me describe my ”problem”. I’ve got a user form with various textboxes. Let’s say that a user enters text in one of the boxes and then copies it to the clipboard using the short command ctrl+c. Is there a way to programmatically copy the copied text to one of the other textboxes just by clicking, let’s say right click in it? Or can one use some sort of short command by ctrl (alt or shift or a combination) + an F-key?

Christer

 

[SQLBI]

Mollethewizard,

You can use the Exit event to copy the text over;

Private Sub txtText1_Exit()

txtText2.Value = txtText1.Value

End sub

Hope this helps.


Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[SkipVought]

Hi,

What happened to ctl+v?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Mollethewizard]

Both your suggestions work but it wasn't what I wanted in this case.

I'll be back whit a more specific question later.

But thanks anyway.

Christer