Embed Spreadsheet in VBA UserForm

[stonysleep]

I've done this before in Excel 2003 but I can't seem to do it in Excel 2007 because the control isn't there in the additional controls list.

In Excel 2003 it was called Microsoft Office Spreadsheet 11.0 and when ticked gave an extra item on the control toolbox which allow you to draw an excel spreadsheet control into a userform.

It's not there in the VBE of Excel 2007 - any ideas how to do it in this version?

Screenshots of the additional controls screen in both versions:
http://img838.imageshack.us/img838/4186/additionalcontrols2003.jpg
http://img204.imageshack.us/img204/175/additionalcontrols2007.jpg

TIA

 

[Jaafar Tribak]

I've done this before in Excel 2003 but I can't seem to do it in Excel 2007 because the control isn't there in the additional controls list.

In Excel 2003 it was called Microsoft Office Spreadsheet 11.0 and when ticked gave an extra item on the control toolbox which allow you to draw an excel spreadsheet control into a userform.

It's not there in the VBE of Excel 2007 - any ideas how to do it in this version?

Screenshots of the additional controls screen in both versions:
http://img838.imageshack.us/img838/4186/additionalcontrols2003.jpg
http://img204.imageshack.us/img204/175/additionalcontrols2007.jpg

TIA

Maybe the OCX control is not registered.

 

[stonysleep]

Thanks - that seems to be the case.
I took the ocx file from the machine with Office 2003 and added it since i don't have the 2007 installer to hand.

For info
I took this folder:
C:\Program Files\Common Files\Microsoft Shared\Web Components\

and then i used this process for adding the control to my 2007 install:
http://office.microsoft.com/en-us/excel-help/add-or-register-an-activex-control-HP010236683.aspx

It seems to have worked, though will try and patch it up with the correct version