https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-visuallzation/m-p/675484#M24333 How to add the value list in some column with the ods excel,like the checkbox. or is there another way to get it? Sun, 09 Aug 2020 15:00:19 GMT Charles_Liu 2020-08-09T15:00:19Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-visuallzation/m-p/675484#M24333 How to add the value list in some column with the ods excel,like the checkbox. or is there another way to get it? Sun, 09 Aug 2020 15:00:19 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-visuallzation/m-p/675484#M24333 Charles_Liu 2020-08-09T15:00:19Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-visuallzation/m-p/677139#M24348 <P>Hi,</P> <P>you could create and run a vba macro from SAS to do this.</P> <P>&nbsp;</P> <P>vba code</P> <PRE>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</PRE> <P><A href="https://support.sas.com/resources/papers/proceedings16/7120-2016.pdf" target="_blank" rel="noopener">HowTo</A>&nbsp;</P> Mon, 17 Aug 2020 07:30:37 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-visuallzation/m-p/677139#M24348 Oligolas 2020-08-17T07:30:37Z