View Single Post
  #5   Report Post  
Old February 8th 18, 09:01 PM posted to microsoft.public.excel.misc
Terry Pinnell[_4_] Terry Pinnell[_4_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2015
Posts: 144
Default Pasting text into VBA macro?

killme2008 wrote:


Use function "GetClipBoardString" to replace your jpg's address.



Private Function GetClipBoardString() As String
On Error Resume Next
Dim MyData As New DataObject
GetClipBoardString = ""
MyData.GetFromClipboard
GetClipBoardString = MyData.GetText
Set MyData = Nothing
End Function


Thanks, much appreciated. But I'm still very much a VBA novice so could
you help me implement that in my specific macro please?

Terry, East Grinstead, UK