Is the a way to copy or paste on double click a cell in a sheet?
If cell = "" .paste (value only!)
If cell <> "" .copy value
Is the a way to copy or paste on double click a cell in a sheet?
If cell = "" .paste (value only!)
If cell <> "" .copy value
Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code
Paste this code in the module that opens and close it.
I have shown you two options.
DoubleClick will copy / paste a single cell
Right Click will copy / paste the selected range
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
It does not work. I get a error on "Selection.PasteSpecial xlPasteValues"
Try this spreadsheet.
I tryd. But olso a error with "Selection.PasteSpecial xlPasteValues"
The Macro works perfectly here. Are you downloading from Post #4?
Yep. The Worksheet_BeforeRightClick works fine.
The Worksheet_BeforeDoubleClick is not working because of a error in Selection.PasteSpecial xlPasteValues
Try this code instead:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks