+ Reply to Thread
Results 1 to 2 of 2

Enable Copy Paste in automatically selected cells

  1. #1
    Registered User
    Join Date
    04-06-2009
    Location
    Germany
    MS-Off Ver
    2010
    Posts
    18

    Enable Copy Paste in automatically selected cells

    Hello all.

    I have a little vba module that uses an external dll to automatically select a cell in one of the worksheets.
    The user then enters a value into the cell and the external dll selects another cell. The user enters then a different value in the new selected cell.
    This works pretty well. However, the values in the cells often only differ in the last one or two characters, which are usually numbers.
    So, it would be great to let the user copy the first entered value and paste it into the next selected cell. But when I use Strg+V in the new cell nothing gets pasted. How would I enable copy paste?
    Ideally, I would also like to set the cursor into the selected cell at the end of the pasted value. So that the user doesn't have to set the cursor manually.
    Is this possible at all? I didn't find any setCursor function or something similar.

    Any hints or tipps are appreciated.
    Best regards,
    heapifyman

  2. #2
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Enable Copy Paste in automatically selected cells

    I'm just thinking off the top of my head, but it may get you started.
    In a Standard Module:
    Please Login or Register  to view this content.
    In the ThisWorkBook module:
    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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