View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bula Bula is offline
external usenet poster
 
Posts: 5
Default Why Spreadsheet worksheet is not a worksheet?

Appreciate very much if you can help.
I add a Spreadsheet control on my userform, and want to reference a
worksheet on the control. But got a "Type mismatch" error.


Set Sht = Me.Controls.Add("OWC10.Spreadsheet.10")

Dim Wksht As Worksheet
Set Wksht =Sht. Worksheets("Sheet1")

Why the worksheet on the Spreadsheet control is not of type worksheet?


George