Dont Use Shapes , use this Code ActiveSheet.OLEObjects.Add(classtype:="Forms.Checkbox.1")
On Wed, Oct 12, 2011 at 6:26 PM, Stuart Redmann <dertop...@web.de> wrote: > 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 > -- Regards Rajan verma +91 9158998701 -- ---------------------------------------------------------------------------------- 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
