Add a check box to an excel spreadsheet using VB Script

Hello,
 
I have a script that creates a Excel file, I wanted to add a check box to on of the cells. I get an error message:
Error:   Wrong number of arguments or invalid property assignment: 'Left'
Code:   800A01C2
 
From this code:
[xlBook.ActiveSheet.OLEObjects.Add ClassType="Forms.CheckBox.1", Link=False, _
DisplayAsIcon=False, Left=Range("A1").Left, _
Top=Range("A1").Top, Width=108, Height=19.5[/code]
 
[[<font][<font]Best Regards

You can't use named arguments (like ClassType:="...") in VBScript;
replace them with positional ones.
(BTW: Thank you for this "useful" "completed VBScript")
 

ehvbs


You can't use named arguments (like ClassType:="...") in VBScript;
replace them with positional ones.
(BTW: Thank you for this "useful" "completed VBScript")

e

 
Thank you so much For point me in the right direction. Here is the working Code:
 
[ xlBook.ActiveSheet.OLEObjects.Add "Forms.CheckBox.1"
With xlBook.ActiveSheet.OLEObjects
.Left = 50
.Top = 10
.Width = 100
.Height = 15
End with [/code]
 
[ 

to EHVBS
 
Both days my comments were cut off after I entered the Code, I also added Thank you I appreciate your input and support.
 
Best regards,