Excel上のチェックボックスの状態を取得するPowerShellのサンプルコード（フォームコントロール）

$excel = New-Object -ComObject Excel.Application
$book = $null

$excel.Visible = $false
$excel.DisplayAlerts = $false

$fileName  = "Book1.xlsx"
$filePath = (Convert-Path .) + "/" + $fileName

$book = $excel.Workbooks.Open($filePath)
$sheet = $book.Sheets("Sheet1")

# チェックボックスの状態取得
write-host($sheet.CheckBoxes("Check Box 1").Value)

[void]$book.Save()
[void]$book.Close($false)
[void][System.Runtime.Interopservices.Marshal]::ReleaseComObject($book)

[void]$excel.Quit()
[void][System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel)

Pause

$excel = New-Object -ComObject Excel.Application
$book = $null

$excel.Visible = $false
$excel.DisplayAlerts = $false

$fileName  = "Book1.xlsx"
$filePath = (Convert-Path .) + "/" + $fileName

$book = $excel.Workbooks.Open($filePath)
$sheet = $book.Sheets("Sheet1")

# グループ内のチェックボックスをまとめて取得する場合 foreach版
foreach($checkbox in $sheet.Shapes("Group1").GroupItems){
    
    if ($sheet.CheckBoxes($checkbox.Name).Value -eq 1){ # CHECK ON
        write-host($sheet.CheckBoxes($checkbox.Name).Caption)
    }
    
}

[void]$book.Save()
[void]$book.Close($false)
[void][System.Runtime.Interopservices.Marshal]::ReleaseComObject($book)

[void]$excel.Quit()
[void][System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel)

Pause

$excel = New-Object -ComObject Excel.Application
$book = $null

$excel.Visible = $false
$excel.DisplayAlerts = $false

$fileName  = "Book1.xlsx"
$filePath = (Convert-Path .) + "/" + $fileName

$book = $excel.Workbooks.Open($filePath)
$sheet = $book.Sheets("Sheet1")

# グループ内のチェックボックスをまとめて取得する場合 for版
for($i=1; $i -le $sheet.Shapes("Group1").GroupItems.Count;$i++){

    $checkboxName = "Check Box " + $i
    if ($sheet.CheckBoxes($checkboxName).Value -eq 1){ # CHECK ON
        write-host($sheet.CheckBoxes($checkboxName).Caption)
    }
}

[void]$book.Save()
[void]$book.Close($false)
[void][System.Runtime.Interopservices.Marshal]::ReleaseComObject($book)

[void]$excel.Quit()
[void][System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel)

Pause