xl vba clipboard

'VBA function to read and write text to the Windows clipboard.

Function Clipboard$(Optional s$)
    Dim v: v = s  'Cast to variant for 64-bit VBA support
    With CreateObject("htmlfile")
    With .parentWindow.clipboardData
        Select Case True
            Case Len(s): .setData "text", v
            Case Else:   Clipboard = .getData("text")
        End Select
    End With
    End With
End Function

'--------------------------------------------------------------------
'Three examples of copying text to the clipboard:
Clipboard "Excel Hero was here."
Clipboard var1 & vbLF var2
Clipboard 123

'To read text from the clipboard:
MsgBox Clipboard

'Note:	This is a solution that does NOT use MS Forms 
'nor the Win32 API. Instead it uses the Microsoft HTML Object Library 
'which is fast and ubiquitous; and this solution respects line feeds.

View another examples Add Own solution

Steve Withington 120 points

                                    'VBA function to read and write text to the Windows clipboard.

Function Clipboard$(Optional s$)
    Dim v: v = s  'Cast to variant for 64-bit VBA support
    With CreateObject(&quot;htmlfile&quot;)
    With .parentWindow.clipboardData
        Select Case True
            Case Len(s): .setData &quot;text&quot;, v
            Case Else:   Clipboard = .getData(&quot;text&quot;)
        End Select
    End With
    End With
End Function

'--------------------------------------------------------------------
'Three examples of copying text to the clipboard:
Clipboard &quot;Excel Hero was here.&quot;
Clipboard var1 &amp; vbLF &amp; var2
Clipboard 123

'To read text from the clipboard:
MsgBox Clipboard

'Note:	This is a solution that does NOT use MS Forms 
'nor the Win32 API. Instead it uses the Microsoft HTML Object Library 
'which is fast and ubiquitous; and this solution respects line feeds.

Thank you! 9

Are there any code examples left?

Find Add Code snippet

New code examples in category VBA

VBA 2022-03-27 20:55:02 excel vba check if all substrings in list are in string
VBA 2022-03-27 20:40:39 excel vba set cell value to empty
VBA 2022-03-27 17:05:52 vba simple quote
VBA 2022-03-27 14:30:19 textbox find and replace vb
VBA 2022-03-27 09:10:21 nested if else in vb.net
VBA 2022-03-27 09:10:09 excel vba string to bits
VBA 2022-03-25 02:00:15 vba verticalalignment
VBA 2022-03-24 12:20:06 Excel web scraping
VBA 2022-03-24 10:11:00 excel vba BitToLong
VBA 2022-03-21 18:00:05 excel vba save file txt

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

copy text to clipboard vba excel vba clipboard contents vba copy to clipboard 2021 vba add clipboard copy to clipboard access vba excel vba copy clipboard to variable vba create clipboard object how to paste data from clipboard in excel vba vba table excel copy to clipboard vba string to clipboard vba file to clipboard vba copy to clipboard excel vba copy to clipboard exec excel vba paste from clipboard to cell vba add to clipboard vba excel copy cell to clipboard excel copy to clipboard vba clipboard set text vba copy from a string in vba excel send text to clipboard vba vba text to clipboard excel vba setclipboard excelvba write to clipboard excel vba write to clipboard xl vba write to clipboard xlvba write to clipboard vba write to clipboard xl vba clipboard xlvba clipboard excelvba clipboard excel vba clipboard copy a text vba vba excel copy to clipboard vba Copy from string copy variable in vba clipboard vba vba copy to clipboard excel vba copy to clipboard Excel VBA code to copy a specific string to clipboard excel vba clipboard copy text vba clipboard vba windows clipboard excel vba windows clipboard excel vba clipboard excel vba copy a string to clipboard

xl vba clipboard

Welcome Back!

Create a Free Account