Excel visuallzation

[Charles_Liu]

How to add the value list in some column with the ods excel,like the checkbox. or is there another way to get it?

[Oligolas]

Hi,

you could create and run a vba macro from SAS to do this.

vba code

Private Sub ActX_Add_CheckBox_Ex1()
    Sheets("Sheet1").CheckBoxes.Add(Left:=Range("E1").Left, Top:=Range("E1").Top, Width:=Range("G1").Width, Height:=Range("E1").Height).Select
    With Selection
        .Caption = "Checkbox XYZ"
    End With
End Sub

HowTo