Results 1 to 6 of 6

Double click VBA to copy & paste to new list

Threaded View

  1. #1
    Registered User
    Join Date
    04-26-2013
    Location
    Harker Heights, TX
    MS-Off Ver
    Excel 2003
    Posts
    3

    Double click VBA to copy & paste to new list

    Hello everyone. I've been trying to find an answer to my question in an existing thread, but haven't been able to do so. I apologize if this has been previously addressed.

    I have a purchase order with all of our items and their corresponding item numbers set up. I've included a search box to limit results, as there are about 700 items included in the list. I would like to be able to search the item list, then double click on the item in the results to add to the actual PO. I am not good with VBA, but have pieced together a code that will copy a cell and paste it into the first line on the PO, but would like each subsequently clicked cell to be added to the next line.

    Also, it would be ideal if I could double click the item on the PO to remove it, and have the following items move up automatically (so as not to leave a blank row).

    Any help from the excel masters would be appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy double-clicked cell to next empty row in different sheet with each double-click
    By erhathaway in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-25-2013, 12:06 AM
  2. 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
  3. [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
  4. [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
  5. List box Double Click Copy and remove item
    By thameem127 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2012, 05:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1