to display content of worksheet on a user form in visual basic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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" <[email protected]>
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
 
Hello Jim,
Thanks for the advice and I see that it will work. However, I seem to have a
problem (as newbies do) I can only access the additional controls dialog from
witin excel but not from within VBE. Can you help me in this regard?
Thank you
JM
 
It seems to work like this...
You must have a form added to the project.
The Toolbox must be displayed.
Then the "Additional Controls" menu item is enabled.
(or you can right-click the Toolbox)
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html



"JohannM" <[email protected]>
wrote in message
Hello Jim,
Thanks for the advice and I see that it will work. However, I seem to have a
problem (as newbies do) I can only access the additional controls dialog from
witin excel but not from within VBE. Can you help me in this regard?
Thank you
JM
 
Back
Top