ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Enable Copy Paste in automatically selected cells (https://www.excelbanter.com/excel-programming/426519-enable-copy-paste-automatically-selected-cells.html)

heapifyman

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


All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com