+ Reply to Thread
Results 1 to 5 of 5

create buttons to copy & paste into a different program

  1. #1
    Registered User
    Join Date
    06-03-2020
    Location
    edinburgh
    MS-Off Ver
    microsoft 365
    Posts
    1

    create buttons to copy & paste into a different program

    Hi everyone

    I'm new to this - delighted such a resource exists !


    I'm trying to create a database of prepared sentences, so that I can click a button and it will COPY the text from the relevant cell that I entered my sentence in.

    I then intend to be able to press Ctrl+V in my other program.

    Can you help me please?

    I thought it'd be a straight forward "click of this button = CTRL+C of cell B2" ….. but I seem to be stuck!

    Thank you in advance! - Mike

  2. #2
    Registered User
    Join Date
    05-14-2020
    Location
    Mauritius
    MS-Off Ver
    Office 365
    Posts
    97

    Re: create buttons to copy & paste into a different program

    Hello,

    paste following code into a module and assign it to your button. It will copy the text from the active cell to the clipboard. After that you can paste it with CTRL+V where ever you want.
    Please Login or Register  to view this content.
    Greetings

    Tor


  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: create buttons to copy & paste into a different program

    Although it has to be asked, what is the benefit of a button over ctrl C, especially if you are then doing ctrl v shortly afterwards?

  4. #4
    Registered User
    Join Date
    07-12-2010
    Location
    North Ayrshire uk
    MS-Off Ver
    Excel 2016
    Posts
    10

    Re: create buttons to copy & paste into a different program

    I have tried so many clips of code to enable me to process data in vb and then paste (ctrl v) once I execute / exit the code.
    When I ctrl v I just get 2 small squares (like non printing characters)
    I usae the following and can confirm that S2 takes the value of the ActiveCell - i.e. it appears to be in the clipboard but pasting later fails

    Please Login or Register  to view this content.

    If I use the CLIPBOARD option on the HOME tab then there is nothing to paste. If I open the tab I have 2 question marks (??)
    Any help appreciated
    Last edited by peterhw; 06-28-2020 at 09:56 AM. Reason: extra info

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,366

    Re: create buttons to copy & paste into a different program

    Administrative Note:

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA program to copy and paste cells from sheet2 to sheet1
    By paind in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-13-2019, 06:35 PM
  2. How to program streaming data copy n paste in VBA ?
    By omega0010 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2013, 05:31 AM
  3. How to create a program that copy and paste between instances of excel???
    By eskimo281 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2011, 11:37 PM
  4. Excel 2007 : copy using paste special to another program
    By robster52 in forum Excel General
    Replies: 0
    Last Post: 09-25-2009, 10:11 AM
  5. Loop Program to Copy/Paste from One Sheet to Another
    By smlaff01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2007, 11:33 AM
  6. [SOLVED] Copy to Clipboard and so that I may paste to any other program
    By tomwashere2 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-22-2006, 10:15 PM
  7. copy paste program
    By msam137 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2005, 02:06 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1