All,

I was using windows for a while and also created a macro to automate my task. Recently I am moved to Mac os and tried to run the same macro in excel for mac 2011, but its not working. I am just trying to copy the content available in textbox3 of the userform to the clipboard, so that i can directly paste that code to my wordpress site.

Found something wrong with this piece of code.

code

Private Sub CommandButton1_Click()
Dim w As New DataObject
w.SetText TextBox3.Text
w.PutInClipboard
End Sub

/code

I heard that data objects are not supported in mac excel. Hence someone pls help me to fix this.

Thanks.