B
Bula
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
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