How to copy value of selected cell to windows clipboard?
I have the code above. I need to copy active cell value for my other uses. Someone said the answer above in bold but then I got error. Could you give me a hint please?
Please Login or Register to view this content.
Selection.Copy
Application.CutCopyMode = False
doesn't work.
Selection.Copy
works but I don't want this cell remain as selected.
Last edited by 1tane1; 05-21-2013 at 06:34 AM.
if problems explain better your goalPlease Login or Register to view this content.
Last edited by patel45; 05-21-2013 at 04:05 AM.
If solved remember to mark Thread as solved
if you use the early bound dataobject you must set a reference to the microsoft forms 2 object library
Josie
if at first you don't succeed try doing it the way your wife told you to
Application.CutCopyMode = False
doesn't work. Clipboard becomes empty.
Could you elaborate more on object library? Because I'm vba illiterate. I just combine vba parts from internet for my own use, but I don't type them, if they are really complicated.
in the vb editor select tools-references on the menu and then find and check the "Microsoft Forms 2.0 Object Library"
As JosephP said, you need to set up reference to Microsoft Forms 2.0 Object Library in order to make your original code to work.
To do this, in VBE go to Tools->References find Microsoft Forms 2.0 Object Library and tick the checkbox
If you are pleased with a member's answer then use the Star icon to rate it.
I added Microsoft Forms 2.0 Object Library. Then I got an error. Debugger highlighted SetText, saying:
Compile error:
Sub or Function not defined
so, now how to define SetText?
Note the dots in front of SetText and PutInClipboardPlease Login or Register to view this content.
That worked perfectly. Thank you very much.Originally Posted by buran
Note the dots in front of SetText and PutInClipboardPlease Login or Register to view this content.
I became happy when my codes work :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks