+ Reply to Thread
Results 1 to 5 of 5

Paste Clipboard in Sheet1 Cell A1

  1. 10-10-2015, 05:12 PM #1
    zplugger
    zplugger is offline
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Paste Clipboard in Sheet1 Cell A1

    Looking for simple code to paste contents in clipboard into A1 with commandbutton

    Thanks
    Last edited by zplugger; 10-11-2015 at 12:13 PM.
    Reply With QuoteRegister To Reply
  2. 10-10-2015, 05:27 PM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Paste Clipboard in Sheet1 Cell A1 

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    Reply With QuoteRegister To Reply
  3. 10-11-2015, 08:20 AM #3
    zplugger
    zplugger is offline
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Paste Clipboard in Sheet1 Cell A1

    Can't seem to get it to work, paste's the wrong data.If I use keyboard ctrl+v it works perfect.Not sure why commandbutton is wrong?
    Reply With QuoteRegister To Reply
  4. 10-11-2015, 10:59 AM #4
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Paste Clipboard in Sheet1 Cell A1

    Try this sample:


    or try this code

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 10-11-2015 at 11:05 AM.
    Reply With QuoteRegister To Reply
  5. 10-11-2015, 12:12 PM #5
    zplugger
    zplugger is offline
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Paste Clipboard in Sheet1 Cell A1

    Perfect Thank You mehmetcik for all your help on this.
    Z
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to copy value of selected cell to windows clipboard?
    By 1tane1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-21-2013, 07:51 AM
  2. Use VBA to paste FROM CLIPBOARD?
    By Tomkat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2013, 01:16 PM
  3. [SOLVED] Excel 2007 : Stange Clipboard behavior prevents proper cut and paste or copy and paste
    By Jim De Boer in forum Excel General
    Replies: 3
    Last Post: 04-13-2012, 12:26 PM
  4. How to copy the selected text in a cell to the clipboard with VBA
    By srschiller in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-16-2010, 10:50 AM
  5. Clipboard paste
    By Ron Sasser in forum Excel General
    Replies: 3
    Last Post: 09-18-2009, 06:18 AM
  6. Copy the sum of selected cells to the clipboard
    By odin205 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-23-2009, 03:29 AM
  7. [SOLVED] Store clipboard before "vba do cut&paste" then recover stored information to clipboard?
    By Marie J-son in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2006, 02:00 AM
  8. [SOLVED] Data on the clipboard is not the same size and shape as the selected area..
    By Darin Kramer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2005, 09:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1