Copy and Paste lost
Sorry this is probably a stupid question, I'm still new at
this coding stuff. I've written some code that calculates a number using the value in a selected cell, places this in a text box, then changes the visiblilty of a couple of controls depending on the cell that is selected. The problem I have now is that when a user wishes to copy and paste from one cell to another the selection looses it's marquee (I think that's what it is called) and therefore paste is nolonger available. How do I solve this? |
Copy and Paste lost
You don't say if the textbox and other controls are on the worksheet or in a
userform. It doesn't seem that your code should interfere with the worksheet but the relationship is not clear. Does you code do any cutting and pasting or set the CutCopyMode False or ScreenUpdating False? If you are using a userform, does the problem occur only when the dialog is open? Try to describe the different conditions when cut/copy/paste works and when it doesn't. Under what circustances (at a particular line of code?) does the selection loose the marquee? (I have seen this called "the marching ants" but marquee is okay by me. <g) Bob Kilmer "Wes" wrote in message ... Sorry this is probably a stupid question, I'm still new at this coding stuff. I've written some code that calculates a number using the value in a selected cell, places this in a text box, then changes the visiblilty of a couple of controls depending on the cell that is selected. The problem I have now is that when a user wishes to copy and paste from one cell to another the selection looses it's marquee (I think that's what it is called) and therefore paste is nolonger available. How do I solve this? |
All times are GMT +1. The time now is 10:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com