lundi 15 octobre 2018

VBScript (not VBA) adding Checkbox in Excel to specific Cell

I have a VBScript that opens an Excel File called Test.xlsx and adds a checkbox. It places this checkbox in cell A1. I'm trying to find out how I can add this check box to another cell instead (for example, go to cell X61 and insert the checkbox there), here's my VBScript

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.DisplayAlerts = True
Set objWorkbook = objExcel.Workbooks.Open("C:\Users\Test\Desktop\Test.xlsx")
Set objWorksheet = objWorkbook.Worksheets(1)

Dim chkBox

Set chkBox = objWorksheet.CheckBoxes.Add(0,0,0,0)
chkBox.Caption = ""

Set objWorkbook = Nothing
Set objWorksheet = Nothing
Set objExcel = Nothing

Thank you




Aucun commentaire:

Enregistrer un commentaire