Get text from clipboard

[Rene Petersen]

Can anyone help me on this one please.

I am creating a inputbox and I want the default text of the inputbox to be
the text I just copied.

Dim Search
Search = InputBox("Type your search", "Search", CLIPBOARDTEXTHERE)

Thanks,
Rene

 

[chijanzen]

you can use SendKeys

Range("A1").Copy
Application.SendKeys "^V"
Search = InputBox("Type your search", "Search")

 

[Tom Ogilvy]

You mihgt want to look at the DataObject in the MSForms 2.0 library:

http://www.cpearson.com/excel/clipboar.htm

Assumes you have copied a text string to the clipboard.

 

[Tony Jollans]

Have you just copied the text in code yourself? Or are you relying on the
user having done it?

If you've done it on code, you should already know what you've copied. If
you're relying on the user you will have to allow for the fact that they may
not have done it and the clipboard may be empty or may contain non-textual
data (but the DataObject is still probably the thing to use).

 

[Doug Robbins - Word MVP]

See the article "Manipulating the clipboard using VBA" at:

http://www.word.mvps.org/FAQs/MacrosVBA/ManipulateClipboard.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP