On Oct 12, 2011 Stuart Redmann 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?
On 12 Okt., rajan verma wrote: > Dont Use Shapes , use this Code > > ActiveSheet.OLEObjects.Add(classtype:="Forms.Checkbox.1") Thank you for your answer. Unfortunately, this yields the same problem on my computer: Even if I add the control in the OLEObjects collection, I still can't see the entry "properties" in the context menu of the newly added control. It looks as if something really weird is going on here. Could you please try to add a control on your computer and look whether you have a proper context menu for this control? I'd be very obliged. 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
