ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   make submenu of checkbox (https://www.excelbanter.com/excel-programming/377557-make-submenu-checkbox.html)

x taol

make submenu of checkbox
 
Dim cmb As CommandBar
Set cmb = CommandBars.Add(Name:=xx, Position:=msoBarPopup, MenuBar:=0,
Temporary:=1)
Set cmb1 = cmb.Controls.Add(msoControlPopup)
Set cmb11 = cmb1.Controls.Add(msoControlPopup)
cmb1.Caption = "aaa"
cmb11.Caption = "bbbb"

Dim cmbPop As CommandBarControl
Set cmbPop = cmb11.Controls.Add(msoControlCheckBox)
With cmbPop
.Caption = "mode"
'~~~~~~~
'~~~~~~~
End With

the following code does not work.
i want to make checkbox control menu.

for example,

submenu1
submenu2 ¡î
submenu3





*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT +1. The time now is 10:29 AM.

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