.................
Set SubMenu = myMenuitem.Controls.Add(Type:=msoControlPopup)
With SubMenu
.Caption = "查看基础数据"
.BeginGroup = True '插入分隔符
End With
Set myMenu = SubMenu.Controls.Add(Type:=msoControlButton)
With myMenu
.FaceId = 18
.TooltipText = "材料编码表"
.Caption = "材料编码表"
.OnAction = "材料编码表"
End With
Set myMenu = SubMenu.Controls.Add(Type:=msoControlButton)
With myMenu
.FaceId = 18
.TooltipText = "产品编码表"
.Caption = "产品编码表"
.OnAction = "产品编码表"
End With
Set myMenu = SubMenu.Controls.Add(Type:=msoControlButton)
With myMenu
.FaceId = 18
.TooltipText = "供应商档案"
.Caption = "供应商档案"
.OnAction = "供应商数据表"
End With
Set myMenu = SubMenu.Controls.Add(Type:=msoControlButton)
With myMenu
.FaceId = 18
.TooltipText = "部门档案"
.Caption = "部门档案"
.OnAction = "部门数据表"
End With
Set myMenu = SubMenu.Controls.Add(Type:=msoControlButton)
With myMenu
.FaceId = 18
.TooltipText = "常用摘要"
.Caption = "常用摘要"
.OnAction = "常用摘要数据表"
End With
......................
End Sub