+ Reply to Thread
Results 1 to 2 of 2

Copy and double click and paste in a specific cell

  1. #1
    Registered User
    Join Date
    06-22-2016
    Location
    united states
    MS-Off Ver
    none :(
    Posts
    1

    Copy and double click and paste in a specific cell

    Ok so in short I am very new to this, and have been doing OK until this stupid roadblock.
    I have a bunch of ID numbers in column A of sheet one. when I double click one, I need the value in that cell when double clicked to be copied into cell b5 in sheet2 and the focus of the screen change from being on sheet one to being on sheet2. Also, lets say that if I want to go back to sheet1 and double click a second number, it should replace the first number on sheet2.
    Thanks in advance, you are helping me more than you know.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Copy and double click and paste in a specific cell

    Is it what you need ...?
    In sheet1 code next put
    Please Login or Register  to view this content.
    Attached Files Attached Files
    - Battle without fear gives no glory - Just try

+ 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. Copy and paste from Listbox to next free cell on double click
    By JohnDoh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2015, 10:25 AM
  2. Copy / paste contents of specific cell on double-click
    By conger in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-22-2015, 08:29 AM
  3. Replies: 0
    Last Post: 05-21-2015, 09:19 AM
  4. double click cell , copy paste to IE , run ....for long url more than 350 characters
    By raj soni in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2014, 09:48 AM
  5. Double-Click Function And Copy-Paste Value In Cell B2
    By FLani in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2013, 02:46 AM
  6. [SOLVED] Double click to copy and paste value to first available row.
    By JO505 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2013, 05:37 PM
  7. [SOLVED] How to copy fr AU:AY & paste to O:S after double click at B in same row
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-14-2012, 03:34 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