Copying Text to Clip Board Using a Macro

  • Thread starter Thread starter robertguy
  • Start date Start date
R

robertguy

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
 
Hi,
Depending on how much text, you could investigate the use of Names to store
your text. You could hide the names if you are interested in Secrecy...

Alternatively, you could use global variables, or even as a property of the
ThisWorkbook class....how much text are we talking here?

Hth,
Oli
 
Back
Top