Software Development Network>> Visual Basic>> Is Clipboard.SetText available in VBA?
Hi,
No, VBA doesn't actually support the Clipboard object.
You can still acess the clipboard, it's just a little more convoluted.
Someone asked the same question in a newsgroup, and the answer will give you what you need: http://groups.google.com/group/microsoft.public.excel.programming/browse_thread/thread/bf310659265585e4/eaa3b5049534d78e lnk=st&q=VBA+%22clipboard.settext%22&rnum=1&hl=en#eaa3b5049534d78e
Is Clipboard.SetText available in VBA?
Vinay Kittur
Hi,
No, VBA doesn't actually support the Clipboard object.
You can still acess the clipboard, it's just a little more convoluted.
Someone asked the same question in a newsgroup, and the answer will give you what you need: http://groups.google.com/group/microsoft.public.excel.programming/browse_thread/thread/bf310659265585e4/eaa3b5049534d78e lnk=st&q=VBA+%22clipboard.settext%22&rnum=1&hl=en#eaa3b5049534d78e