PDA

View Full Version : Solved: [Solved]Copying contents of textbox to clipboard



nals14
10-09-2007, 10:36 AM
Hi,
I have a Userform in excel. This has a huge text box. The user is allowed to copy the data from this text box. Once they select the data in the text box with the mouse they have to use the keys Ctrl+C to copy they have been complaining. They use tablets and so they find it very difficult to pull up the keyboard to do it everytime.

Is it possible for me to have another button in the User form which says 'Copy to clipboard'. Then they can close the form and go to any sheet in the file and paste it?

Is this even possible. Need your help please. :help

Thanks,
Nalini.

lucas
10-09-2007, 11:26 AM
This is one way: see attached

nals14
10-09-2007, 11:43 AM
Wow, Thank you so much for the solution. This is more intiutive than the 'Copy To ClipBoard' button I had in mind.

Really appreciate your help.

Thank you vert much.

Nalini.:cloud9:

lucas
10-09-2007, 11:46 AM
Hi Nalini,
Mark your thread solved by using the thread tools at the top of the page...works much better. You're welcome.