if you want to see the Properties .. you can select Property Option from Developer Tab in Control Menu
On Wed, Oct 12, 2011 at 8:48 PM, rajan verma <rajanverma1...@gmail.com>wrote: > 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 > -- 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
