Worksheet in Userform

[Steve]

I want to open a specific worksheet within a userform, this would enable the
user to input values on this worksheet within the userform where the data
from this worksheet would then be placed in the open workbook. Is there
anyway to open an excel spreadsheet in a userform and manipulate it in that
userform.

Thanks,
Steve

 

[Harald Staff]

Hi Steve

You can use a Microsoft Office Spreadsheet control on a userform (should be
found under additional controls in the toolbox). This will not be a live
representation of one of your workbook's worksheet though, so you must write
some code to transfer data between them.

HTH. Best wishes Harald