Copy Spread Sheet to a Userform SpreadSheet Control.

[[email protected]]

I have downloaded and added Spreadsheet Control to the Userform Control ToolBox.

I am trying now to show the spreadsheet on the Userform; I run and populate the Workbook/sheet. Now I am trying to copy it to the Speadsheet on the UserForm.

I am able to so this; but my worksheet has shapes(pictures); I am not able to figure how to copy the pics.

This is what I am trying to do;

Please Login or Register  to view this content.

Another way I was thinking to change my macros to copy directly to the Userform.spreadsheet.

Any input would be appreciated.

Thanks

[Kenneth Hobson]

If you need all that, why not just show the Userform in modeless format and let them work on it directly?

[[email protected]]

Since I added OWC to my Excel 2013; to be able to have the spreadsheet on the form; but Now I am wondering if I should try this with Excel Services/SharePoint. Not that much familiar with these; where should I start; books. tutorials to show me what to do.

Many Thanks