Worksheet in form

[Maz]

Hi all,

I want to create a VB form that displays a section of a
worksheet Range A1:B7 in sheet 3. I can add in an active x
control MS spreadsheet 10.0 but that simply show a blank
sheet. How do I link it to the range I want displayed?

Many thanks

Maz

 

[Jim Rech]

As far as I know there is no way to directly link the spreadsheet component
to an Excel worksheet. So you'd have to populate the SS component by code.
Like this where the SS component is on a userform:

Me.Spreadsheet1.Range("A1").Value = Sheet1.Range("A1").Value

--
Jim Rech
Excel MVP
| Hi all,
|
| I want to create a VB form that displays a section of a
| worksheet Range A1:B7 in sheet 3. I can add in an active x
| control MS spreadsheet 10.0 but that simply show a blank
| sheet. How do I link it to the range I want displayed?
|
| Many thanks
|
| Maz