"Spreadsheet1" is the default name for the Microsoft Spreadsheet Control.
It can be found in the "additional controls" option on the VBE Toolbox.
--
Jim Cone
Portland, Oregon USA



"Simon Lloyd"

wrote in message
You can't call UserForm1.Spreadsheet1.Cells...etc, the userform is not
an object or property of the spreasdhseet (sheet or sheets), the
userform will have either comboboxes, listboxes or textboxes that will
hold values.
--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)