Inserting worksheet in a Userform

[antaeusguy]

As I know, normal controls such as CommandButton, ComboBox, TextBox, OptionButton etc... can be added into a Userform.

But, is it possible to add a worksheet within a Userform? Where the cells & grids are within a Userform...

 

[ChrisM]

Yes, there is an ActiveX control for an entire Excel instance that you can add. Just go to your form's control toolbox, right click, choose additional controls, then go down to microsoft office spreadsheet.

Note, the one time I tried this, I kept getting annoying ActiveX security warnings every time I opened the file, and as the file was for a number of other people I ended up going a different route.