Thread: Save VBA Variable to Clipboard

so I guess this brings me back to my original question... Is there a way to save the variable to the clipboard other than placing it in a cell and do the ole automated copy and paste routine?

Thanks for sticking with me on this.

Hello Janos,

Does this site allow you to post HTML code? A lot of sites don't for security reasons.

So I went back to tlafferty's thread to try it again.... For some reason this time it worked which is really weird because I added the lines verbatum and I kept getting an object define error... This time it's working like a charm... The only thing I can think of is that it wa getting hung up after I already had an error the first time I tried it.. After closing the program and restarting it (a few days later I might add), it is now running like a champ.... Sometimes I hate computers. Especially when they make you look like the fool..

Well this I think this is fully solved now.... Thanks everyone for your inputs.

Originally Posted by tlafferty

Added a couple of lines to your code:

Sub Createcode()
Dim DataObj As New MSForms.DataObject

Range("A1").Select
i = 0
C = 0

Do
If ActiveCell.Offset(0, i).Value = "" Then GoTo A
i = i + 1
Loop

A:
Do
If ActiveCell.Offset(C, 0).Value = "" Then GoTo B
C = C + 1
Loop


B:
i = i - 1
C = C - 1
Ti = 0
 
CD = ""
MsgCode = CD

MsgBox ("Your code has been generated.  Just go to where you want to post it and select Paste.")
DataObj.SetText CD
DataObj.PutInClipBoard
End Sub

Hello Janos,

When I was a DS in the Navy, I had a rubber mallet in my tool box. Just for situations like this one.

Despite the mallet you probably overlooked my suggestion in post #12, which does everything (reading & writing, no clipboard needed) in 1 go.