ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Managing Cut/Copy & Paste During Program Run (https://www.excelbanter.com/excel-programming/445274-managing-cut-copy-paste-during-program-run.html)

Cory Layman

Managing Cut/Copy & Paste During Program Run
 
I have a couple programs that make use of copy and paste during code
run to move around entire rows or columns. The problem I run into is
that the programs might run for an extended period of time so, the
user has time to work on other things during that period. However,
while the code is running, the user loses the ability to copy and
paste because the program is hitting the clipboard buffer.

My question: Is there a way to do a cut/copy&paste where VBE use a
clipboard buffer seperate from the system-wide clipboard buffer the
user would be utilizing? Any work around I've been able to dream up
so far would be horribly slow and cumbersome.

Thanks,

Cory

GS[_2_]

Managing Cut/Copy & Paste During Program Run
 
Cory Layman brought next idea :
I have a couple programs that make use of copy and paste during code
run to move around entire rows or columns. The problem I run into is
that the programs might run for an extended period of time so, the
user has time to work on other things during that period. However,
while the code is running, the user loses the ability to copy and
paste because the program is hitting the clipboard buffer.

My question: Is there a way to do a cut/copy&paste where VBE use a
clipboard buffer seperate from the system-wide clipboard buffer the
user would be utilizing? Any work around I've been able to dream up
so far would be horribly slow and cumbersome.

Thanks,

Cory


When your code is done with each cut/copy/paste, try clearing the
clipboard so it's empty...

Application.CutCopyMode = False

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc




All times are GMT +1. The time now is 03:43 AM.

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