kenny123
10-11-2011, 08:11 PM
"Microsoft Listview Control 6.0" can edit cells as worksheet
or only for a view?
"Microsoft Listview Control 6.0" can set title names,but "Microsoft Spreadsheet Control 11.0" can't do these?
I found error in the following code which set in UserForm_Initialize, i don't know why.(userform already with Spreadsheet1)
Private Sub UserForm_Initialize()
...
With Spreadsheet1
.ActiveSheet.Range(Cells(1, 1), Cells(2, 2)).Interior.ColorIndex = 3
End With
...
end sub
But the code can run in worksheet.
sub XXX()
ActiveSheet.Range(Cells(1, 1), Cells(2, 2)).Interior.ColorIndex = 3
end sub :dunno
or only for a view?
"Microsoft Listview Control 6.0" can set title names,but "Microsoft Spreadsheet Control 11.0" can't do these?
I found error in the following code which set in UserForm_Initialize, i don't know why.(userform already with Spreadsheet1)
Private Sub UserForm_Initialize()
...
With Spreadsheet1
.ActiveSheet.Range(Cells(1, 1), Cells(2, 2)).Interior.ColorIndex = 3
End With
...
end sub
But the code can run in worksheet.
sub XXX()
ActiveSheet.Range(Cells(1, 1), Cells(2, 2)).Interior.ColorIndex = 3
end sub :dunno