• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Spreadsheet Control In UserForms

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.
 
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.
 
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 ; )
 
Back
Top