clipboard

  1. V

    Copy variable to clipboard

    I want to copy a variable to the Clipboard and I have used this code in the past and it worked. Now it just returns ?? Any help would be appreciated. Sub test() 'Microsoft Forms 2.0 Object Library is referenced Dim MyData As DataObject Dim strClip As String strClip = Range("J" &...
  2. Johnny C

    VBA clipboard going wrong when File Explorer open

    I've got this code attached to a button on my QAT. it copies the file path, filename, sheetname and selection range to the clipboard so that it can be quickly pasted into the sheet or emails. It mostly works fine. However when File Explorer is open, it usually just puts 2 ascii 10's into the...
  3. M

    PasteSpecial macro not working after cut

    Hi, I am trying to cut a range in workbook1 and paste it using a PasteSpecial macro in Workbook2, but I am getting an error. The PasteSpecial macro works fine when I copy the range instead of cutting it. In macro 1, I use the following code to cut a range into the clipboard: Range(Temp...
  4. I

    VBA to copy to clipboard on MAC?

    I have Excel 2019 (16.29.1) I do not see an option to insert a userform or enable object library 2.0. Is there a way in Excel for Mac to setup a macro to copy cell value to clipboard? Thanks for the help!
  5. D

    Mouse Without Borders -- causing bad Excel Lag, esp w/ copy-paste

    After troubleshooting why my Excel 2007 seemed to be unnaturally sluggish, especially with copy/paste functions, I traced the problem to Microsoft's "Mouse Without Borders" app (which lets you share a single mouse/keyboard with two different computers, and glide from one desktop onto the other...
  6. L

    Saving a variable into clipboard

    Hello guys, i have a file that i only want to be editable by user forms. For that result i protect the sheet and unprotect it only when running the macro. But users are still able to browse through the data, copy it. Most of the time they will edit specific places by copying and searching via...
  7. rediffusion

    `Insert Note` ··· Clipboard.GetImage - how make it work?

    ? Cross-post!I have «Microsoft Office 365 2019». ? I have <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation...
  8. D

    Macro error when copying pasting from clipboard

    Trying to copy a column and paste using the clipboard on the Home ribbon. When I do this it usually converts the text values to numbers (for numbers that I copied and pasted externally) Run-time error: 1004 Paste method of worksheet class failed Sheets("Sheet2").Select Range("K2").Select...
  9. D

    Format Painter: Clear All in Clipboard not working

    In the Home tab, when I click "Format Painter", it opens the Clipboard. Sometimes there is an item there called (preview not available). I will hit Clear All but it doesn't get cleared. Also, when I Copy my selection in order to add to the Clipboard, nothing happens. Anyone know what is the issue?
  10. B

    error message due to cell being blank

    Hi, What do need to add to this piece of coding so that the it doesn't stop if no information is inserted in cell Q5 theString = Range(" Q5").Value 'cast to string theObject.SetText theString theObject.PutInClipboard 'copy from cell B2 to clipboard...
  11. B

    Creating a Word Document from an Excel spredsheet - formatting

    Hi, I presently have coding that will create the word document but I was wondering if it is possible to have coding that will help with the formatting of the Word document and the removal of bookmarks that are no used (no information in the corresponding cell in excel) the person fills...
  12. T

    Determine if clipboard object is text or image before pasting

    Hi all, Had a bit of a google but not sure if this is possible or not... I have a sheet that imports data that is copied to the clipboard from another sheet... the other sheet data will open in protected view - so if people don't click enable editing then it copies the selection as an image...
  13. S

    Clipboard History issue in VB Editor

    If I use Clipboard History in the VB Editor, the text content of the clipboard is hidden unless the Copy was done in Notepad or equivalent. Copies done in VBE paste OK, but you're pasting blind, which is useless My problem is that I work in VBE most of the time, and I've never been able to...
  14. P

    Access VBA: Create 2D Array, and Then Update Table With Array Data

    Hello, and as a non-programmer I struggle much with 2D arrays. I waive the proverbial white flag of surrender, and any help would be most merciful. I have a text download, which I have converted to a one dimensional array. But I would like to convert it to a two-dimensional array, which would...
  15. V

    Put Two values into Clipboard with VBA

    I need to put value of 2 cells saying cell 'A1" and 'A2' into window's clipboard to use for other purpose Dim obj as DataObject Obj.SetText range("A1") Obj.PutInClipboard Obj.SetText left(range("A2"),4) Obj.PutInClipboard When i run code (f5), then opened window's clipboard, it only saved the...
  16. J

    VBA Code To Copy multiple text strings from buttons for single paste?

    What code do I need to use to instruct a VBA form to copy one or several text strings to clipboard at the activation of one button? Essentially I want to compile different text strings then paste in (any other) application with single <ctrl+v>. I have figured out how to write the code to copy a...
  17. A

    Clipboard Annoyance

    For some reason when I copy an item it is not showing up in my clipboard. It has been working flawlessly until now. When I copy a cell the Paste All and Clear all buttons are ghosted. It will copy and paste using the buttons on the toolbar but nothing shows on Clipboard pane. Thanks.
  18. C

    Copy contents of VBA csv export to Clipboard

    I have a functioning VBA macro to export the contents of a worksheet to a .csv file. I am curious if anyone knows how to supplement the below script so that the contents of that exported .csv file are copied to the system Clipboard for pasting into a separate program. The current method is to...
  19. Y

    Paste all clipboard items with match formatting

    how do i Paste all clipboard items with match formatting?
  20. D

    Does Application.CutCopyMode = False clear the Excel clipboard or not? Confused.

    I've gotten in the habit of pasting Application.CutCopyMode = False at the end of nearly any VBA code that executes any kind of Copy/Paste function, since I read somewhere that it essentially clears any items from the Clipboard / releases any memory associated with it (and I'm often doing quite...

Some videos you may like

This Week's Hot Topics

Top