hello all,
I have a double click target at column B (can i have a limit for B20:B100 in stead of entire column B?)
DoubleClick @ B20 then copy from Range("AU20:AY20") paste into Range("O20:S20")
DoubleClick @ B25 then copy from Range("AU25:AY25") paste into Range("O25:S25")
Please help me with this if it's possible.
Regards,
tt3
Last edited by tuongtu3; 12-14-2012 at 03:34 PM. Reason: Solved
Hi, tt3,
Ciao,
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi Holger,
The code works but I want to change to:
Double click at column B (You just gave me a code)
UserForm.Show (I have this)
CommandButton3 (I need code in this button to copy and paste from AU to O in same row)
Thank you very much for your time and help.
Regards,
tt3
Hi, tuongtu3,
Fine that the code works, but why donīt you ask what you are really for? What you want may bring you in trouble. If you use BeforeDoubeClick you have a Target in the worksheet, if you want to apply an UserForm you need to take care to get the proper row instead on relying on a target. And thatīs exactly the point: you need either to find the proper row or rely on information that I donīt have to determine the row. Least of all you could rely on ActiveCell instead of Target but that may lead to unwanted results.The code works but I want to change to
Ciao,
Hoger
Hi Holger,
Im so sorry because Im too slow and dont know ahead of exactly what I want. Until I see your code then I think of something else that I can do on my workbook. You can take a look at my sample in the attached and I need a commandButton3 code to copy and paste at my first post. Or you may assist me a code on commandButton3.
Thank you very much for your time and help.
Regards,
tt3
Hi, tt3,
behind Sheet1:
Code for CommandButtomn3:Please Login or Register to view this content.
HTHPlease Login or Register to view this content.
Holger
Hi Holger,
Yes, that works. Thank you very much for your time and help.
Regards,
tt3
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks