Using Paste command

[Marty]

Hi- I need to capture a number from a screen. When the
PRINT button is selected, the number is copied to the
clipboard. Now I need to paste that number into my VBA
macro code.

I see Paste Method and PasteOK Property commands, but am
at a loss as how to use them.

How can I store the number on the clipboard in my VBA
code?

Thanks for any and all help,

Marty

 

[Jonathan West]

Hi- I need to capture a number from a screen. When the
PRINT button is selected, the number is copied to the
clipboard. Now I need to paste that number into my VBA
macro code.

I see Paste Method and PasteOK Property commands, but am
at a loss as how to use them.

How can I store the number on the clipboard in my VBA
code?

Thanks for any and all help,

Hi Marty

This article shows you how to get text on and off the clipboard.

Manipulating the clipboard using VBA
http://word.mvps.org/FAQs/MacrosVBA/ManipulateClipboard.htm