ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copying TEXT from Textbox to other location (https://www.excelbanter.com/excel-programming/278182-copying-text-textbox-other-location.html)

jason

Copying TEXT from Textbox to other location
 
I have a simple userform with a text box that returns the fullname of
the activeworkbook.I then want to be able to manually copy & paste
this text to another location e.g e-mail,worksheet or word document.At
the moment it won't let me copy it - is there a specific property for
the Text box that I need to change to allow copy/paste?

Help greatly appreciated

J

Tom Ogilvy

Copying TEXT from Textbox to other location
 
Highlight the text in the textbox and do Ctrl+C

That should copy it.

Regards,
Tom Ogilvy

jason wrote in message
om...
I have a simple userform with a text box that returns the fullname of
the activeworkbook.I then want to be able to manually copy & paste
this text to another location e.g e-mail,worksheet or word document.At
the moment it won't let me copy it - is there a specific property for
the Text box that I need to change to allow copy/paste?

Help greatly appreciated

J




jason

Copying TEXT from Textbox to other location
 
Cheers Tom
Strange how it isn't possible to use the mouse to copy once it has been highlighted!

Jason

"Tom Ogilvy" wrote in message ...
Highlight the text in the textbox and do Ctrl+C

That should copy it.

Regards,
Tom Ogilvy

jason wrote in message
om...
I have a simple userform with a text box that returns the fullname of
the activeworkbook.I then want to be able to manually copy & paste
this text to another location e.g e-mail,worksheet or word document.At
the moment it won't let me copy it - is there a specific property for
the Text box that I need to change to allow copy/paste?

Help greatly appreciated

J



All times are GMT +1. The time now is 11:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com