 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / September 2006to display content of worksheet on a user form in visual basic
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).  SignatureJim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "JohannM" <JohannM@discussions.microsoft.com> 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 > Using a UserForm in Excel 2002... > In the VBE, show the Toolbox then under the Tools menu, select "Additional Controls" [quoted text clipped - 4 lines] > user form and then paste a "picture" of your spreadsheet directly into the "picture" > property in the properties window (yes, it works). 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) SignatureJim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "JohannM" <JohannM@discussions.microsoft.com> 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 "Jim Cone" wrote: > Using a UserForm in Excel 2002... > In the VBE, show the Toolbox then under the Tools menu, select "Additional Controls" [quoted text clipped - 4 lines] > user form and then paste a "picture" of your spreadsheet directly into the "picture" > property in the properties window (yes, it works). |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.