View Single Post
  #5   Report Post  
Old February 8th 18, 08: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 = ""
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