dixiematic
Technical User
Hello,
I wonder, why I cannot add an OLE object:I am using the example from the Excel 2007 Vba Help:
Worksheets _("List1").OLEObjects.Add "Forms.CommandButton.1", Left:=10, top:=10, Height:=20, Width:=100
and works fine.
It works fine with "Forms.CommandButton.1" and "Forms.CheckBox.1" and "Forms.ListBox.1" too, but fails with "Forms.Label.1". What am I doing wrong?
Dixiematic
I wonder, why I cannot add an OLE object:I am using the example from the Excel 2007 Vba Help:
Worksheets _("List1").OLEObjects.Add "Forms.CommandButton.1", Left:=10, top:=10, Height:=20, Width:=100
and works fine.
It works fine with "Forms.CommandButton.1" and "Forms.CheckBox.1" and "Forms.ListBox.1" too, but fails with "Forms.Label.1". What am I doing wrong?
Dixiematic