[RESOLVED] Include Spreadsheet object in UserForm

[DKenny]

Is it possible to include a variable size, both rows and columns, spreadsheet object in a user form and have it link back to a range in the main xls file?



thanks
Declan

[JustinLabenne]

There is a spreadsheet control you can use form the Userfro mToolbox under additional controls.

Not real sure right off about Linking, but this is a workaround:

Private Sub UserForm_Activate()
Spreadsheet1.Range("A1").Value = Range("A1").Value
End Sub

[dannymking]

Not too sure as to why you would want to link back to the original file.. you might want to look into pulling the range into an array and then displaying it inside a list box.

What exactly are you trying to achieve here..

[DKenny]

I need the user to see and potentially edit the data in this range and my problem is letting edits occur while the code is running.

Thats why I'm exploring copying the data from the range into a temp s/sheet (held in a form) and then writing back to my main range.

I hope this makes sense...

[dannymking]

If you want to allow the editting of the spreadsheet behind then Link like Justin has pointed out.

[DKenny]

Thanks Justin - thats just what I needed.