Hi,

I have the following two additional controls in my
VBE/view/controls toolbox:

1. MS Office Spreadsheet 10.0
2. MS Office Spreadsheet 9.0

I am trying to add the MS Office Spreadsheet 10.0 control
in a user form runtime via vba code. The problem is that,
the control that is generated is of version 9.0. Does
anybody know how to change this. Any help is greatly
appreciated.

My code looks like this:

Private Sub UserForm_Initialize()
Dim oSheet As Control
Set oSheet = Me.Controls.Add("Spreadsheet")
With oSheet
..Width = 220
..Height = 150
..Left = 8
..Top = TopPos + 40
End With
End Sub

thanks in advance,
Sudhakar