+ Reply to Thread
Results 1 to 2 of 2

twist on Ctrl-x, Ctrl-v

Hybrid View

  1. #1
    Registered User
    Join Date
    12-27-2016
    Location
    Ontario, Canada
    MS-Off Ver
    2010
    Posts
    38

    twist on Ctrl-x, Ctrl-v

    I would like to something that is similar to behavior to ctrl-x and ctrl-v but with additional commands. So the user is on a particular cell and when the user clicks ctrl-x on that field I do some validations and pickup the location and value in the cell along with the one beside it. Then I want the user to click on another cell and when they click ctrl-v I will run some validations to make sure this is an allowable place to paste the information. There are two things I am trying to accomplish; 1) this variation on the ctrl-x/ctrl-v is only for a particular worksheet 2) I can't figure out how store the 'cut' information until such as a time tat the user chooses another valid cell and clicks ctrl-v. Meaning the cut takes place but the code won't continue until the user clicks a valid destination and clicks ctrl-v.

    I did ok picking up the data from the cut, but waiting for the user to choose another cell and clicking ctrl-v for paste is where I have no idea how to do.

    Thanks

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,035

    Re: twist on Ctrl-x, Ctrl-v

    Untested theory ...

    Create a hidden "storage" Worksheet. Use Worksheet activate/deactivate event handlers to change and restore the behaviour of the ctrl-x and ctrl-v key combinations. When you press ctrl-x, store the cells on the hidden sheet and, when you press ctrl-v, validate, cut and paste the cells.

    Or, something like that.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Replies: 4
    Last Post: 04-27-2021, 11:49 AM
  2. [SOLVED] CTRL+C & CTRL+V copy single but pasting tab delimited spaced
    By Jack7774 in forum Excel General
    Replies: 4
    Last Post: 03-20-2015, 08:23 AM
  3. Disable cut,copy,paste(including ctrl x, ctrl c n ctrl v)
    By Ramboexcel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2014, 01:00 AM
  4. [SOLVED] Move Ctrl + F6 or make a macro that mimicks what Ctrl + F6 does
    By Jacc in forum Word Formatting & General
    Replies: 4
    Last Post: 08-18-2014, 03:28 AM
  5. Help needed : Unable to use CTRL+C or CTRL+D to copy formula
    By Elangovan89 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-09-2014, 10:20 AM
  6. Replies: 3
    Last Post: 08-02-2013, 12:06 PM
  7. Ctrl+pg up and Ctrl+pg Down Dont work, New & unprotected documents
    By desert_dweller5 in forum Excel General
    Replies: 2
    Last Post: 09-10-2012, 07:44 AM

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