Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BackStyle Property misbehavior
Greetings,
Sorry for crosspost. Figured maybe more appropriate here than M.P.Excel where I tried yesterday...or does the question even make sense? The sequence below works to create and then set options on CommandButton1, Label1 and Frame1 objects - *except* that the visual effect of BackStyle is not seen. Public Sub addLabel() Sheet2.OLEObjects.Add "Forms.Label.1", _ Left:=100, Top:=75, Height:=15, Width:=200 End Sub Public Sub nameLabel() Sheet2.Label1.Name = "title1" End Sub Public Sub setLabel() Sheet2.title1.BackStyle = 0 Sheet2.title1.Caption = "My Text" Sheet2.title1.Font.Bold = 1 Sheet2.title1.Font.Italic = 1 Sheet2.title1.Font.Size = 12 End Sub However, the value *is* set correctly per the script when I look at the object properties after the sheet is created and all these objects added. Changing the property manually in the properties dialog *on those objects created by the script* also has no visual effect - the label/button/frame keeps it's white background. OTOH, if I add a Label manually, I can set BackStyle to 0 and it immediately becomes transparent. All other properties (except size/location) are identical to the manually-created 'control' that does accept and reflect the value of BackStyle. Saving and re-opening the file doesn't change appearance or behavior any. What am I missing, beyond that it smells like a bug? By the way, I have the same behavior on excel 2000 and 2003 and on several different machines. Side question - Add say a Command1 button manually to the sheet from the toolbar. Right-click on it to get to the menu with 'properties' on it. It seems to be hit-or-miss whether the full menu or an abbreviated one without 'Properties' comes up. Do these things have 'hot' areas that produce different menus? Or what? TIA - Lynn. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
BackStyle Property misbehavior
Hi Lynn,
Unfortunately setting the backstyle of ActiveX worksheet controls to transparent does not persist, at least not after clicking. Concerning the right click context menu, normally the commandbar named "ActiveX Control" ought to pop-up with Properties & View code items. But an ActiveX is also a Shape so the "Shapes" or "Excel Control" toolbars might popup in slightly different circumstances, particularly if you have more than one selected. Regards, Peter T "Lyndon Rickards" wrote in message ... Greetings, Sorry for crosspost. Figured maybe more appropriate here than M.P.Excel where I tried yesterday...or does the question even make sense? The sequence below works to create and then set options on CommandButton1, Label1 and Frame1 objects - *except* that the visual effect of BackStyle is not seen. Public Sub addLabel() Sheet2.OLEObjects.Add "Forms.Label.1", _ Left:=100, Top:=75, Height:=15, Width:=200 End Sub Public Sub nameLabel() Sheet2.Label1.Name = "title1" End Sub Public Sub setLabel() Sheet2.title1.BackStyle = 0 Sheet2.title1.Caption = "My Text" Sheet2.title1.Font.Bold = 1 Sheet2.title1.Font.Italic = 1 Sheet2.title1.Font.Size = 12 End Sub However, the value *is* set correctly per the script when I look at the object properties after the sheet is created and all these objects added. Changing the property manually in the properties dialog *on those objects created by the script* also has no visual effect - the label/button/frame keeps it's white background. OTOH, if I add a Label manually, I can set BackStyle to 0 and it immediately becomes transparent. All other properties (except size/location) are identical to the manually-created 'control' that does accept and reflect the value of BackStyle. Saving and re-opening the file doesn't change appearance or behavior any. What am I missing, beyond that it smells like a bug? By the way, I have the same behavior on excel 2000 and 2003 and on several different machines. Side question - Add say a Command1 button manually to the sheet from the toolbar. Right-click on it to get to the menu with 'properties' on it. It seems to be hit-or-miss whether the full menu or an abbreviated one without 'Properties' comes up. Do these things have 'hot' areas that produce different menus? Or what? TIA - Lynn. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
BackStyle Property misbehavior
Thank you Peter for at least confirming my sanity, and
one of the clunkier areas of Micro$loth. - Lynn. Peter T wrote: Hi Lynn, Unfortunately setting the backstyle of ActiveX worksheet controls to transparent does not persist, at least not after clicking. Concerning the right click context menu, normally the commandbar named "ActiveX Control" ought to pop-up with Properties & View code items. But an ActiveX is also a Shape so the "Shapes" or "Excel Control" toolbars might popup in slightly different circumstances, particularly if you have more than one selected. Regards, Peter T "Lyndon Rickards" wrote in message ... Greetings, Sorry for crosspost. Figured maybe more appropriate here than M.P.Excel where I tried yesterday...or does the question even make sense? The sequence below works to create and then set options on CommandButton1, Label1 and Frame1 objects - *except* that the visual effect of BackStyle is not seen. Public Sub addLabel() Sheet2.OLEObjects.Add "Forms.Label.1", _ Left:=100, Top:=75, Height:=15, Width:=200 End Sub Public Sub nameLabel() Sheet2.Label1.Name = "title1" End Sub Public Sub setLabel() Sheet2.title1.BackStyle = 0 Sheet2.title1.Caption = "My Text" Sheet2.title1.Font.Bold = 1 Sheet2.title1.Font.Italic = 1 Sheet2.title1.Font.Size = 12 End Sub However, the value *is* set correctly per the script when I look at the object properties after the sheet is created and all these objects added. Changing the property manually in the properties dialog *on those objects created by the script* also has no visual effect - the label/button/frame keeps it's white background. OTOH, if I add a Label manually, I can set BackStyle to 0 and it immediately becomes transparent. All other properties (except size/location) are identical to the manually-created 'control' that does accept and reflect the value of BackStyle. Saving and re-opening the file doesn't change appearance or behavior any. What am I missing, beyond that it smells like a bug? By the way, I have the same behavior on excel 2000 and 2003 and on several different machines. Side question - Add say a Command1 button manually to the sheet from the toolbar. Right-click on it to get to the menu with 'properties' on it. It seems to be hit-or-miss whether the full menu or an abbreviated one without 'Properties' comes up. Do these things have 'hot' areas that produce different menus? Or what? TIA - Lynn. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel misbehavior | Excel Discussion (Misc queries) | |||
Enter key misbehavior | Excel Discussion (Misc queries) | |||
Problem setting BackStyle on Label | Excel Discussion (Misc queries) | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
Checkbox BackStyle Bug or Not? | Excel Programming |