Spreadsheet Control In UserForms

[indi visual]

I'm looking to view a live range of cells in a UserForm (where the user can edit the cells on the user form if they want to - where the data they enter will also enter to the actual worksheet).


I've been experimenting with the following:


Private Sub UserForm_Initialize()

Me.Spreadsheet1.Cells.Range("CX950:HF968").Value = _

ThisWorkbook.Worksheets("Sheet1").Range("CX950:HF968").Value

End Sub


I guess I have to first draw the spreadsheet control box on my userform first.


The problem is it's not in my tool box options.


Any help is super appreciated.

 

[indi visual]

I've found a link here

http://www.microsoft.com/download/en/details.aspx?DisplayLang=en&id=22276


I got the spreadsheet control box in for anyone using Excel 2010 and it's missing.


However, it's now telling me that my script is out of range?


Any help would be awesome.

 

[indi visual]

I got it knocked out


I checked tools in the editor to see if it was there "Microsoft Spreadsheet Control..."

It wasn't, so I downloaded it from the link above.

I rebooted, went back into Excel and checked it.

I drew the speadsheet control box on my userform (revised it accordingly).

Used the code above in the user initialize code and voila ; )