Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enable copy and paste numbers to and from Calculator oldneezer Excel Discussion (Misc queries) 2 August 16th 09 02:08 AM
How to enable Copy/Paste on protected work sheet? dveeraj New Users to Excel 1 August 10th 09 06:49 PM
Enable Copy and Paste Functions in a protected worksheet LRay67 Excel Programming 8 August 7th 08 02:35 PM
How I can copy / paste a selected cells to other columns in Excel M.Rafat Excel Discussion (Misc queries) 4 November 7th 06 05:42 AM
How do I copy selected cells in excel and paste into word table REVA Excel Programming 2 January 4th 06 09:43 PM


All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"