Hello newsgroup, I tried the following code to create an ActiveX checkbox under Excel:
- Create new workbook. - Add following code to worksheet 1 Sub test() Me.Shapes.AddOLEObject "Forms.CheckBox.1", , False, False, , , , 100, 100, 100, 100 End Sub - Execute code Now I have got a worksheet with a single checkbox. If I try to view the properties of this checkbox, I enable the design mode of the Toolbox toolbar and make a right-click on the checkbox. The options that are available are "Cut", "Copy", "Paste", separator, "Checkbox-Object", "Show graphics symbol bar", separator, "Grouping", "Order", separator, "Assign Macro" (greyed out) and "Format object" (these are my translation of the German version of Excel, so these menu entries may be different in the English version). I miss the entry "Properties". However, if I add a checkbox by hand, I can display the properties of this checkbox through the context menu. Once the property window is up, I can select the VBA added checkbox and can edit its properties without problems. I use Excel 2003 (11.8231.8221) SP3. Can anybody re-produce this behaviour? Is this a bug? If it is a bug, does it go away under Excel 2003+x, x>0? Thanks in advance, Stuart -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
