VBA - Copy cell content to clipboard on double-click & remove quotes

[kingofcamden]

Hi all,

I've tried several macros now to copy cell content, in a specified range and on double-click, to the clipboard.

I found a single-click version that seems to work:

Please Login or Register  to view this content.

...however, it includes " at the beginning and end of the copied string (at least when I paste outside of Excel), which I assume is happening because my copied content has multiple lines of text.
That is getting a bit annoying now as I'm posting into a JIRA ticket and the " are messing up the formatting.

I then also found this, which is using the Microsoft Forms 2.0 library (added) and supposed to be a double-click variant of the above (which would be my preference), but doesn't seem to be working at all:

Please Login or Register  to view this content.

Does anyone have an idea how I could tweak the 2nd code (double-click variant) to work + implement some sort of code that prevents it from including the quotes " to the copied text in the clipboard?

No luck finding anything on here or other forums, but looks like that has been asked a few times already

Any help is appreciated!
Many thanks!

[kingofcamden]

Hi all,

After some crazy trial and error, I think I found a solution to my problem. The above code for copying a cell on double-click works, however, my Microsoft Forms 2.0 library was corrupted. I basically saved the file as an .xls and then again as a .xlsm & readded my code, which seems to have reset the libraries. All is working now, which is great (plus it also copies without the question marks)!

Now I'm trying to optimize this code slightly. Basically, I want to double click any cell in range W37:W1000, but copy the cell content 2 columns to the right of that cell (so in column Y). Assume I need to add some kind of offset to the below? Just don't know where and how to start really...

Hope someone can help?
Thank you!!

Please Login or Register  to view this content.

[kingofcamden]

Hi all,

After trying a few things out, I think I got it to work so posting my solution here if anyone else needs it:

Please Login or Register  to view this content.

Thanks!