Hi,
Is it possible to copy the cell contents on double click (Editing mode) and select all the contents and copy to clipboard by VBA
Hi,
Is it possible to copy the cell contents on double click (Editing mode) and select all the contents and copy to clipboard by VBA
Last edited by Barieq; 10-03-2023 at 05:08 AM.
Hi there,
The following code will copy a single cell (value and formatting) to the clipboard. It should be entered in the "ThisWorkbook" VBA CodeModule.
Please Login or Register to view this content.
Hope this helps.
Regards,
Greg M
Sorry, may be I have not mentioned you clearly.
I need to select the cell contents (As we do it on Edit Mode F2) and select all the contents and copy later I need to paste it to some other application.
You can use a macro like this:
Either called from a double-click event like Greg showed or run manually.Please Login or Register to view this content.
Rory
@rorya,
Thank you, this is exactly what I wanted. How can I amend this code to sheet double click event, I tried but no result.
Is it just for one particular sheet?
No, I need to apply this event to multiple sheets from range F7:F & lastrow.
If they are all in the same workbook, then you can use the event Greg suggested:
pasted into the ThisWorkbook module of that workbook.Please Login or Register to view this content.
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
@rorya
Acknowledgement appreciated - many thanks!
Best regards,
Greg M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks