ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   why doesn't this caption property work (https://www.excelbanter.com/excel-programming/319781-why-doesnt-caption-property-work.html)

Brian

why doesn't this caption property work
 
Dim objCmdBar As CommandBarControl

Set objCmdBar = Application.CommandBars("Worksheet Menu
Bar").Controls.Add(Type:=msoControlButton, befo=9)

objCmdBar.Visible = True
objCmdBar.Caption = "Test"

It just produces blank menuitems

Thanks




Brian

why doesn't this caption property work
 
DUUUUUHHHHHHHHHHHHHHHHHHHHHHHH

msoControlPopup

sorry, mind blank thing


"Brian" wrote in message
...
Dim objCmdBar As CommandBarControl

Set objCmdBar = Application.CommandBars("Worksheet Menu
Bar").Controls.Add(Type:=msoControlButton, befo=9)

objCmdBar.Visible = True
objCmdBar.Caption = "Test"

It just produces blank menuitems

Thanks







All times are GMT +1. The time now is 06:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com