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.

--
Regards,
Tom Ogilvy


"Rene Petersen" wrote in message
...
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