Set variable to clipboard contents?

  • Thread starter Thread starter Fred Smith
  • Start date Start date
F

Fred Smith

Is it possible to set a variable to the contents of the clipboard? That is,
what is the VBA equivalent of MyVar = Ctrl-V?
 
look up GetFromClipboard Method. Copies data from the Clipboard to a
DataObject. Your variable has to be a DataObject. You ca transfer from that
to other variable types.
 
Fred.

First, set a reference to the MSForms library (in VBA, Tools
menu, then References), and use code like the following:

Dim DataObj As New MSForms.DataObject
Dim S As String
DataObj.GetFromClipboard
S = DataObj.GetText
Debug.Print S

See also www.cpearson.com/excel/clipboar.htm .

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy contents of variable into clipboard 6
Macro to restore previous content of clipboard 3
Copy variable to clipboard 3
Assign Selection to a Variable 2
Copy value of textbox to clipboard for use in another application 5
Get text from Win Clipboard into VBA variable 10
Reference named range in closed workbook 23
Copy from clipboard in excel/vba: size limit ? 1

Back
Top