Using a UserForm in Excel 2002...
In the VBE, show the Toolbox then under the Tools menu, select "Additional Controls"
and look for "Microsoft Office Spreadsheet" and checkmark it.
After you add the control to the userform, you can copy your worksheet and paste
it into the control.
Another way (but it doesn't look as good) would be to add an Image control to the
user form and then paste a "picture" of your spreadsheet directly into the "picture"
property in the properties window (yes, it works).
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"JohannM"
wrote in message
In essence I would like to display the content of my excel work book in a
user form in Visual Basic. Can anybody please give me some advice on how to
achieve this. Be as detailed as possible since I am still very new at Visual
Basic.
Thank you.
JM