LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
robertguy
 
Posts: n/a
Default Copying Text to Clip Board Using a Macro


Hi,

is it possible to store text e.g. a standard script which I constantly
use within the code of a macro ?

The macro would be assigned to a button and when the button is “clicked
on” it would copy this text to the clip board which will then allow me
to paste it into another application.

Currently this text is stored in a cell and I reference this cell and
copy to clip board this way, buy I want to get away from storing text
this way.

Any help would be grateful appreciates

Many thanks


Rob


--
robertguy

44 Married two kids
------------------------------------------------------------------------
robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963
View this thread: http://www.excelforum.com/showthread...hreadid=345787

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying a workbook with custom toolbar assigned to a macro Matt W Excel Discussion (Misc queries) 1 February 4th 05 10:46 PM
How do I insert a clip art picture into a text box in word 2003 Lindas Excel Discussion (Misc queries) 2 January 26th 05 04:47 PM
Macro Text into Excell Krefty Excel Discussion (Misc queries) 2 December 20th 04 09:14 PM
Macro or Function to make text size to suite text Length? lbbss Excel Discussion (Misc queries) 4 December 14th 04 07:53 PM
copying text into a macro pagelocator Excel Worksheet Functions 1 November 24th 04 08:52 AM


All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"