excel grid in VBA user form

[baitmaster]

Hi all

I have seen VBA user forms, with what appears to be a range of excel cells loaded into them - or at least, a grid that can be made to work in the same way, and looks exactly like a section from a worksheet

How can I add this grid? I cant find an object that looks like this, to add to my toolbox

thanks

 

[Andrew Poulsom]

It's a Spreadsheet Control. You may find it in the list when you choose Tools|Additional Controls, eg Microsoft Office Spreadsheet 10.0.

 

[baitmaster]

thanks Andrew, however I cant find this, or anything that looks like it... Is it only available in VB.net perhaps?

 

[Andrew Poulsom]

What version of Excel do you have? You can download the Office Web Components from:

http://www.microsoft.com/downloads/...2C-402E-4F72-97A5-E0FD290D4B76&displaylang=en

 

[baitmaster]

I'm on XL07, the download is for 03, so I assume that I should have this in 07?

 

[Andrew Poulsom]

It doesn't come with Office 2007, but you can still use it:

http://blogs.msdn.com/b/joelo/archive/2007/01/05/what-happened-to-the-office-web-components.aspx

 

[ccpsc]

Does it have this in Office 2010? Or can I use 03 in 2010?

 

[Andrew Poulsom]

From a quick test the Office Spreadsheet Controls 10.0 and 11.0 appear to work in Excel 2010.