VBA code to copy user form textbox content to clipboard

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.

Im not sure about Mac workings....but
you could 'cheat' and write the data to a text file 'clipboard'.
then open it when you need it back.

Please Login or Register  to view this content.

Hi Sir,

First of all thanks a lot for your response. Tried running the code, but encountering the following error;

"Constants, fixed-length strings, arrays, user-defined types and Declare statements not allowed as Public members of object modules"

Hence please check and do the needful.

Thanks.

All,

Anyone would you please respond.

Thanks

Anyone pls help

Kindly help

All,

Could you please update on the above query.

Thaks.