How to paste web data into a Userform Spreadsheet

[hogstrom]

Hi everyone!

I have created a userform on which I have a spreadsheet.

The idea is that the user can paste specific data into this and then this data is exported into a open workbook in a predefined way.

If I paste the data into a regular worksheet there is no problems but when pasting into the userform spreadsheet the data gets weird. Some characters ends up in the spreadsheet as "square" character.

What is wrong, my hypothesis is that this has something to do with datatype (Which was set as default to "XMLDATA") which can be found in properties for a userform spreadsheet but I haven´s found anything about it!

Thanks for any responses

 

[Bluejay07]

Hi,

Since you are referencing 'spreadsheet' and 'workbook', I'm thinking that your post may be better suited in the VBA forum.

http://www.tek-tips.com/threadminder.cfm?pid=707