insert a spreadsheet control at design time

  • Thread starter Thread starter mpg
  • Start date Start date
M

mpg

using vb express 2005
trying to insert a spreadsheet control onto a form.
i have added the reference for excel object 11.0
i cant figure out where to FIND the object to paste the control on my form
at design-time.

hope someone can help (it's easy in access-vba, but i cant figure it out
here)
mike g
 
Try this:

Display the main form in your project.
In the Toolbox, right-click on the Components header (any of the
categories will do, this just makes it easier to find). Select
Add/Remove items.
In the box that appears, select the COM Components tab.
Check the box next to "Microsoft Office Spreadsheet 11.0" and click OK.
That will produce an Excel control that you can drag to your form.

Hope that helps!
Nate
 
oh yah..!!!

thanks a bunch for that.
i was about to write my own spreadsheet control with draw functions. yikes.
 
Back
Top