自动生成VBA窗体菜单
'***************************
'* 菜单类 *
'***************************
Option Explicit
Private WithEvents MenuBar_MenuItem As MSForms.Label '菜单项
Private WithEvents WorkForm As MSForms.UserForm '工作窗口
Private WithEvents MenuBar As MSForms.Image '菜单栏
Private BackMenu_BackGroud As MSForms.Image '菜单背景图片
Private BackMenu_Caption As MSForms.Label '菜单标题标签
Private Const DISTANCE As Integer = 5 '菜单与左边框距离
Private Const MENUTOP As Integer = 2 '菜单项顶点Y轴位置
Private Const MENUHEIGHT As Integer = 14 '菜单项高度
Private intIndex As Integer '索引变量
Private sAction As String '宏名称变量
Private Property Let Index(N As Byte) '指定索引属性
intIndex = N
End Property
Private Property Get Index() As Byte '获得陇望蜀索引属性
Index = intIndex
End Property
Private Property Let OnAction(sAct As String) '行为属性
sAction = sAct
End Property
Private Property Get OnAction() As String
OnAction = sAction
End Property
Public Sub AddMenu(wform As MSForms.UserForm, sCaption As String, sAction As String, Optional Acc As String = vbNullString)
Dim MenuLeft As Single, MenuWidth As Single
'由两个标签和一个图形控件组成一个主菜单项
MenuCount = MenuCount + 1 '主菜单项总数加1
Index = MenuCount '设置索引
Set WorkForm = wform
With WorkForm
Set MenuBar = .FormMenuBar
Set BackMenu_Caption = .Controls.Add("forms.label.1") '添加一个标签,显示菜单标题
With BackMenu_Caption
.Accelerator = Acc
.AutoSize = True
.BackStyle = fmBackStyleTransparent
.Caption = sCaption
.Font = "宋体"
.Font.Size = 9
.Name = "BackMenu_Caption" & MenuCount
.TextAlign = fmTextAlignCenter
.Top = MENUTOP + 3
.WordWrap = False
.Visible = True
End With
If MenuCount = 1 Then
MenuLeft = DISTANCE
Else
With .Controls("BackMenu_Caption" & MenuCount - 1)
MenuLeft = .Left + .Width
End With
End If
MenuWidth = BackMenu_Caption.Width + 10
Set BackMenu_BackGroud = .Controls.Add("forms.image.1") '添加一个image,作为背景图片
With BackMenu_BackGroud
.Name = "BackMenu_BackGroud" & MenuCount
.BorderStyle = fmBorderStyleNone
.Move MenuLeft, MENUTOP, MenuWidth, MENUHEIGHT
.BackStyle = fmBackStyleTransparent
.PictureSizeMode = fmPictureSizeModeStretch
BackMenu_Caption.AutoSize = False
BackMenu_Caption.Left = .Left
BackMenu_Caption.Width = .Width
End With
BackMenu_Caption.ZOrder '将标签置前
Set MenuBar_MenuItem = .Controls.Add("forms.label.1") '添加一个Label,用于触发事件
With MenuBar_MenuItem
.Name = "MenuBar_MenuItem" & MenuCount
.BorderStyle = fmBorderStyleNone
.BackStyle = fmBackStyleTransparent
With BackMenu_BackGroud
MenuBar_MenuItem.Move .Left, .Top, .Width, .Height
End With
End With
End With
OnAction = sAction
End Sub
Private Sub MenuBar_MenuItem_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
If Button = 1 Then bMenuSelected = True: Menu_Select
End Sub
Private Sub MenuBar_Click()
UnSelectLastMenu
bMenuSelected = False
End Sub
Private Sub MenuBar_MenuItem_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
UnSelectLastMenu
Call Menu_Select
End Sub
Private Sub MenuBar_MouseMove1(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
If Not bMenuSelected Then UnSelectLastMenu
End Sub
Private Sub WorkForm_Click() '窗体单击时
UnSelectLastMenu
bMenuSelected = False
End Sub
Private Sub WorkForm_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
If Not bMenuSelected Then UnSelectLastMenu '窗体
End Sub
Private Sub Menu_Select() '选择菜单
On Error Resume Next
Dim Pt_Menu_RightBottom As POINTAPI, Pt_Menu_LeftTop As POINTAPI
With WorkForm
UnSelectLastMenu
Set LastSelect_Menu = BackMenu_BackGroud
With BackMenu_BackGroud
.BorderStyle = fmBorderStyleSingle
.BorderColor = RGB(0, 0, 128)
.BackStyle = fmBackStyleOpaque
If bMenuSelected = False Then
WorkForm.Controls("BackMenu_BackGroud" & Index).BackColor = &HFFC0C0
Else
WorkForm.Controls("BackMenu_BackGroud" & Index).BackColor = &HE0E0E0
pt.X = MenuBar_MenuItem.Left * 1.33
pt.Y = (MenuBar_MenuItem.Top + MenuBar_MenuItem.Height) * 1.33 + 3
ClientToScreen hForm, pt
If OnAction "" Then
Application.Run OnAction
End If
End If
End With
End With
End Sub
Private Sub UnSelectLastMenu() '取消上次选择
If Not LastSelect_Menu Is Nothing Then
With LastSelect_Menu
.Picture = LoadPicture()
.BackStyle = fmBackStyleTransparent
.BorderStyle = fmBorderStyleNone
End With
End If
End Sub
'********本模块结束**********
'***************************
'* 菜单执行模块 *
'***************************
Public Type POINTAPI
X As Long
Y As Long
End Type
Public Declare Function FindWindow Lib "user32.dll" Alias"FindWindowA"(ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Public Declare Function ClientToScreen Lib"user32"(ByVal hwnd As Long, lpPoint As POINTAPI) As Long
Public Popup_Menu As CommandBar '指定弹出式菜单
Public LastSelect_Menu As MSForms.Image '最后选择的菜单
Public MenuCount As Integer '子菜单数量
Public hForm As Long '窗口句柄
Public intLevel As Integer '级别标识,用于设置Radio菜单(游戏菜单中:初级,中级,高级)
Public bAbortEnabled As Boolean '标识放弃菜单项是否可用
Public bItemCheck As Boolean '标识音效菜单是否CheckOn
Public bMenuSelected As Boolean '标识菜单是否点击
Public pt As POINTAPI '定义点
Public faceid As Integer '图标ID
Public faceidselect As Integer '选择的图标
Public fistid As Integer '第一个图标号
Public lastid As Integer '最后一个图标号
Public selectrow,selectcol as integer
Public Mcro(50) AS String
SUB 文件()
Clear_menu '清除弹出菜单上菜单项
Dim cmb As CommandBarControl
AddCustomCommandBarPopup1 "打开 ", "", False, True,33,""
AddCustomCommandBarPopup1 "新建 ", "BB", False, True,18,""
AddCustomCommandBarPopup2 ("另存为 ")
Set cmb = Application.CommandBars("CELL").Controls("另存为 ")
AddCustomCommandBarPopup3 cmb, "OFFICE 97-2003文件 ", "DD", False, True, 3, ""
Set cmb = Application.CommandBars("CELL").Controls("另存为 ")
AddCustomCommandBarPopup4 cmb, "OFFICE 2007工作表 "
Set cmb = Application.CommandBars("CELL").Controls("另存为 ").Controls("OFFICE 2007工作表 ")
AddCustomCommandBarPopup3 cmb, "office 2007启用宏的工作表 ", "FF", False, True, 0, ""
Set cmb = Application.CommandBars("CELL").Controls("另存为 ").Controls("OFFICE 2007工作表 ")
AddCustomCommandBarPopup3 cmb, "OFFICE 2007工作表 ", "GG", False, True, 253, ""
Popup_Menu.ShowPopup pt.X, pt.Y
END SUB
SUB 公式()
Clear_menu '清除弹出菜单上菜单项
Dim cmb As CommandBarControl
AddCustomCommandBarPopup1 "文本 ", "WB", False, True,7,""
AddCustomCommandBarPopup2 ("名称 ")
Set cmb = Application.CommandBars("CELL").Controls("名称 ")
AddCustomCommandBarPopup3 cmb, "定义 ", "DY", False, True, 0, ""
Set cmb = Application.CommandBars("CELL").Controls("名称 ")
AddCustomCommandBarPopup4 cmb, "单元格 "
Set cmb = Application.CommandBars("CELL").Controls("名称 ").Controls("单元格 ")
AddCustomCommandBarPopup3 cmb, "合并 ", "HB", False, True, 592, ""
Set cmb = Application.CommandBars("CELL").Controls("名称 ").Controls("单元格 ")
AddCustomCommandBarPopup3 cmb, "从属 ", "CS", False, True, 564, ""
Popup_Menu.ShowPopup pt.X, pt.Y
END SUB
SUB 开发工具()
Clear_menu '清除弹出菜单上菜单项
Dim cmb As CommandBarControl
AddCustomCommandBarPopup1 "插入 ", "CR", False, True,548,""
AddCustomCommandBarPopup1 "模式 ", "MS", False, True,590,""
AddCustomCommandBarPopup2 ("宏 ")
Set cmb = Application.CommandBars("CELL").Controls("宏 ")
AddCustomCommandBarPopup3 cmb, "录制宏 ", "LZH", False, True, 205, ""
Set cmb = Application.CommandBars("CELL").Controls("宏 ")
AddCustomCommandBarPopup3 cmb, "安全性 ", "AQX", False, True, 279, ""
Set cmb = Application.CommandBars("CELL").Controls("宏 ")
AddCustomCommandBarPopup3 cmb, "查看代码 ", "CKDM", False, True, 289, ""
Popup_Menu.ShowPopup pt.X, pt.Y
END SUB
SUB 窗口()
Clear_menu '清除弹出菜单上菜单项
Dim cmb As CommandBarControl
AddCustomCommandBarPopup1 "并列比较 ", "BLBJ", False, True,250,""
AddCustomCommandBarPopup1 "冻结 ", "DJ", False, True,288,""
AddCustomCommandBarPopup1 "隐藏 ", "YC", False, True,237,""
AddCustomCommandBarPopup1 "拆分 ", "CF", False, True,292,""
AddCustomCommandBarPopup1 "取消冻结 ", "QXDJ", False, True,232,""
Popup_Menu.ShowPopup pt.X, pt.Y
END SUB
SUB 工具()
Clear_menu '清除弹出菜单上菜单项
Dim cmb As CommandBarControl
AddCustomCommandBarPopup1 "拼写检查 ", "PXJC", False, True,246,""
AddCustomCommandBarPopup2 ("保护 ")
Set cmb = Application.CommandBars("CELL").Controls("保护 ")
AddCustomCommandBarPopup3 cmb, "保护工作表 ", "BHGZB", False, True, 277, ""
Set cmb = Application.CommandBars("CELL").Controls("保护 ")
AddCustomCommandBarPopup3 cmb, "保护工作薄 ", "BHGZBB", False, True, 312, ""
Set cmb = Application.CommandBars("CELL").Controls("保护 ")
AddCustomCommandBarPopup3 cmb, "工作表菜单栏 ", "gzbcdl", False, True, 142, ""
Set cmb = Application.CommandBars("CELL").Controls("保护 ")
AddCustomCommandBarPopup3 cmb, "图表菜单栏 ", "tbgjl", False, True, 164, ""
Popup_Menu.ShowPopup pt.X, pt.Y
END SUB
SUB 常用()
Clear_menu '清除弹出菜单上菜单项
Dim cmb As CommandBarControl
AddCustomCommandBarPopup1 "格式 ", "gs", False, True,108,""
AddCustomCommandBarPopup1 "数据透视表 ", "sjtsb", False, True,125,""
AddCustomCommandBarPopup1 "图表 ", "tb", False, True,127,""
AddCustomCommandBarPopup1 "审阅 ", "sy", False, True,124,""
AddCustomCommandBarPopup1 "窗体 ", "ct", False, True,128,""
AddCustomCommandBarPopup1 "停止录制 ", "tzlz", False, True,185,""
AddCustomCommandBarPopup2 ("外部数据 ")
Set cmb = Application.CommandBars("CELL").Controls("外部数据 ")
AddCustomCommandBarPopup3 cmb, "公式审核 ", "gssh", False, True, 129, ""
Set cmb = Application.CommandBars("CELL").Controls("外部数据 ")
AddCustomCommandBarPopup3 cmb, "全屏显示 ", "qpxs", False, True, 130, ""
Set cmb = Application.CommandBars("CELL").Controls("外部数据 ")
AddCustomCommandBarPopup3 cmb, "循环引用 ", "xhye", False, True, 132, ""
Set cmb = Application.CommandBars("CELL").Controls("外部数据 ")
AddCustomCommandBarPopup4 cmb, "VisualBasic "
Set cmb = Application.CommandBars("CELL").Controls("外部数据 ").Controls("VisualBasic ")
AddCustomCommandBarPopup3 cmb, "Web ", "web", False, True, 173, ""
Set cmb = Application.CommandBars("CELL").Controls("外部数据 ").Controls("VisualBasic ")
AddCustomCommandBarPopup3 cmb, "控件工具箱 ", "kjgjx", False, True, 174, ""
Set cmb = Application.CommandBars("CELL").Controls("外部数据 ").Controls("VisualBasic ")
AddCustomCommandBarPopup3 cmb, "退出设计模式 ", "tcsjms", False, True, 162, ""
Set cmb = Application.CommandBars("CELL").Controls("外部数据 ").Controls("VisualBasic ")
AddCustomCommandBarPopup3 cmb, "刷新 ", "sx", False, True, 165, ""
Set cmb = Application.CommandBars("CELL").Controls("外部数据 ").Controls("VisualBasic ")
AddCustomCommandBarPopup3 cmb, "监视窗口 ", "jsck", False, True, 168, ""
Set cmb = Application.CommandBars("CELL").Controls("外部数据 ").Controls("VisualBasic ")
AddCustomCommandBarPopup3 cmb, "数据透视表字段列表 ", "sjtsbzdb", False, True, 170, ""
Set cmb = Application.CommandBars("CELL").Controls("外部数据 ").Controls("VisualBasic ")
AddCustomCommandBarPopup3 cmb, "边框 ", "bk", False, True, 178, ""
Set cmb = Application.CommandBars("CELL").Controls("外部数据 ").Controls("VisualBasic ")
AddCustomCommandBarPopup3 cmb, "保护 ", "bh", False, True, 160, ""
Set cmb = Application.CommandBars("CELL").Controls("外部数据 ").Controls("VisualBasic ")
AddCustomCommandBarPopup3 cmb, "文本到语音 ", "wbdyy", False, True, 164, ""
Popup_Menu.ShowPopup pt.X, pt.Y
END SUB
SUB 列表()
Clear_menu '清除弹出菜单上菜单项
Dim cmb As CommandBarControl
AddCustomCommandBarPopup1 "并排比较 ", "bpbj1", False, True,180,""
AddCustomCommandBarPopup1 "绘图 ", "bpbj2", False, True,182,""
AddCustomCommandBarPopup1 "数据透视图菜单 ", "bpbj3", False, True,184,""
AddCustomCommandBarPopup2 ("工作簿标签 ")
AddCustomCommandBarPopup2 ("单元格 ")
Set cmb = Application.CommandBars("CELL").Controls("单元格 ")
AddCustomCommandBarPopup3 cmb, "列 ", "bpbj6", False, True, 190, ""
Set cmb = Application.CommandBars("CELL").Controls("单元格 ")
AddCustomCommandBarPopup3 cmb, "行 ", "bpbj7", False, True, 192, ""
Set cmb = Application.CommandBars("CELL").Controls("单元格 ")
AddCustomCommandBarPopup3 cmb, "单元格 ", "bpbj8", False, True, 194, ""
Set cmb = Application.CommandBars("CELL").Controls("单元格 ")
AddCustomCommandBarPopup3 cmb, "柱形图 ", "bpbj9", False, True, 196, ""
Set cmb = Application.CommandBars("CELL").Controls("单元格 ")
AddCustomCommandBarPopup3 cmb, "行 ", "bpbj10", False, True, 198, ""
Set cmb = Application.CommandBars("CELL").Controls("单元格 ")
AddCustomCommandBarPopup4 cmb, "工作表 "
Set cmb = Application.CommandBars("CELL").Controls("单元格 ").Controls("工作表 ")
AddCustomCommandBarPopup3 cmb, "XLM 单元格 ", "bpbj12", False, True, 202, ""
Set cmb = Application.CommandBars("CELL").Controls("单元格 ").Controls("工作表 ")
AddCustomCommandBarPopup3 cmb, "文档 ", "bpbj13", False, True, 204, ""
Set cmb = Application.CommandBars("CELL").Controls("单元格 ").Controls("工作表 ")
AddCustomCommandBarPopup3 cmb, "桌面 ", "bpbj14", False, True, 206, ""
Set cmb = Application.CommandBars("CELL").Controls("单元格 ").Controls("工作表 ")
AddCustomCommandBarPopup3 cmb, "非默认拖放 ", "bpbj15", False, True, 208, ""
Set cmb = Application.CommandBars("CELL").Controls("单元格 ").Controls("工作表 ")
AddCustomCommandBarPopup3 cmb, "自动填充 ", "bpbj16", False, True, 210, ""
Set cmb = Application.CommandBars("CELL").Controls("单元格 ").Controls("工作表 ")
AddCustomCommandBarPopup3 cmb, "按钮 ", "bpbj17", False, True, 212, ""
Set cmb = Application.CommandBars("CELL").Controls("单元格 ").Controls("工作表 ")
AddCustomCommandBarPopup3 cmb, "对话框 ", "bpbj18", False, True, 214, ""
Popup_Menu.ShowPopup pt.X, pt.Y
END SUB
SUB 序列()
Clear_menu '清除弹出菜单上菜单项
Dim cmb As CommandBarControl
AddCustomCommandBarPopup1 "图形区 ", "bpbj20", False, True,218,""
AddCustomCommandBarPopup1 "基底和墙纸 ", "bpbj21", False, True,220,""
AddCustomCommandBarPopup1 "趋势线 ", "bpbj22", False, True,222,""
AddCustomCommandBarPopup1 "图表 ", "bpbj23", False, True,224,""
AddCustomCommandBarPopup1 "设置数据系列格式 ", "bpbj24", False, True,226,""
AddCustomCommandBarPopup2 ("设置数据轴格式 ")
Set cmb = Application.CommandBars("CELL").Controls("设置数据轴格式 ")
AddCustomCommandBarPopup3 cmb, "设置图例项格式 ", "bpbj26", False, True, 230, ""
Set cmb = Application.CommandBars("CELL").Controls("设置数据轴格式 ")
AddCustomCommandBarPopup3 cmb, "编辑栏 ", "bpbj27", False, True, 232, ""
Set cmb = Application.CommandBars("CELL").Controls("设置数据轴格式 ")
AddCustomCommandBarPopup3 cmb, "数据透视表上下文菜单 ", "bpbj28", False, True, 234, ""
Set cmb = Application.CommandBars("CELL").Controls("设置数据轴格式 ")
AddCustomCommandBarPopup3 cmb, "查询 ", "bpbj29", False, True, 236, ""
Set cmb = Application.CommandBars("CELL").Controls("设置数据轴格式 ")
AddCustomCommandBarPopup3 cmb, "查询布局 ", "bpbj30", False, True, 238, ""
Set cmb = Application.CommandBars("CELL").Controls("设置数据轴格式 ")
AddCustomCommandBarPopup4 cmb, "自动计算 "
Set cmb = Application.CommandBars("CELL").Controls("设置数据轴格式 ").Controls("自动计算 ")
AddCustomCommandBarPopup3 cmb, "对象/图形区 ", "bpbj32", False, True, 242, ""
Set cmb = Application.CommandBars("CELL").Controls("设置数据轴格式 ").Controls("自动计算 ")
AddCustomCommandBarPopup3 cmb, "标题栏(图表) ", "bpbj33", False, True, 244, ""
Popup_Menu.ShowPopup pt.X, pt.Y
END SUB
SUB 框架()
Clear_menu '清除弹出菜单上菜单项
Dim cmb As CommandBarControl
AddCustomCommandBarPopup1 "数据透视图快捷菜单 ", "bpbj35", False, True,248,""
AddCustomCommandBarPopup1 "拼音信息 ", "bpbj36", False, True,250,""
AddCustomCommandBarPopup1 "自动合计 ", "bpbj37", False, True,252,""
AddCustomCommandBarPopup1 "选择性粘贴下拉框 ", "bpbj38", False, True,254,""
AddCustomCommandBarPopup2 ("查找格式 ")
Set cmb = Application.CommandBars("CELL").Controls("查找格式 ")
AddCustomCommandBarPopup3 cmb, "替换格式 ", "bpbj40", False, True, 258, ""
Set cmb = Application.CommandBars("CELL").Controls("查找格式 ")
AddCustomCommandBarPopup3 cmb, "列表区域快捷菜单 ", "bpbj41", False, True, 260, ""
Set cmb = Application.CommandBars("CELL").Controls("查找格式 ")
AddCustomCommandBarPopup3 cmb, "列表区域布局快捷菜单 ", "bpbj42", False, True, 262, ""
Set cmb = Application.CommandBars("CELL").Controls("查找格式 ")
AddCustomCommandBarPopup3 cmb, "XML 区域快捷菜单 ", "bpbj43", False, True, 264, ""
Set cmb = Application.CommandBars("CELL").Controls("查找格式 ")
AddCustomCommandBarPopup3 cmb, "列表区域布局快捷菜单 ", "bpbj44", False, True, 266, ""
Set cmb = Application.CommandBars("CELL").Controls("查找格式 ")
AddCustomCommandBarPopup3 cmb, "艺术字 ", "bpbj45", False, True, 268, ""
AddCustomCommandBarPopup2 ("图片 ")
Set cmb = Application.CommandBars("CELL").Controls("图片 ")
AddCustomCommandBarPopup3 cmb, "阴影设置 ", "bpbj47", False, True, 272, ""
AddCustomCommandBarPopup2 ("三维设置 ")
Set cmb = Application.CommandBars("CELL").Controls("三维设置 ")
AddCustomCommandBarPopup3 cmb, "绘图画布 ", "bpbj49", False, True, 276, ""
Set cmb = Application.CommandBars("CELL").Controls("三维设置 ")
AddCustomCommandBarPopup3 cmb, "组织结构图 ", "bpbj50", False, True, 278, ""
Set cmb = Application.CommandBars("CELL").Controls("三维设置 ")
AddCustomCommandBarPopup3 cmb, "图示 ", "bpbj51", False, True, 280, ""
Set cmb = Application.CommandBars("CELL").Controls("三维设置 ")
AddCustomCommandBarPopup3 cmb, "墨迹绘图与书写 ", "bpbj52", False, True, 282, ""
Set cmb = Application.CommandBars("CELL").Controls("三维设置 ")
AddCustomCommandBarPopup3 cmb, "墨迹注释 ", "bpbj53", False, True, 284, ""
AddCustomCommandBarPopup2 ("边框 ")
Set cmb = Application.CommandBars("CELL").Controls("边框 ")
AddCustomCommandBarPopup3 cmb, "边框 ", "bpbj55", False, True, 288, ""
Set cmb = Application.CommandBars("CELL").Controls("边框 ")
AddCustomCommandBarPopup4 cmb, "绘图边框 "
Set cmb = Application.CommandBars("CELL").Controls("边框 ").Controls("绘图边框 ")
AddCustomCommandBarPopup3 cmb, "图表类型 ", "bpbj57", False, True, 292, ""
Set cmb = Application.CommandBars("CELL").Controls("边框 ").Controls("绘图边框 ")
AddCustomCommandBarPopup3 cmb, "图案 ", "bpbj58", False, True, 294, ""
Set cmb = Application.CommandBars("CELL").Controls("边框 ").Controls("绘图边框 ")
AddCustomCommandBarPopup3 cmb, "字体颜色 ", "bpbj59", False, True, 296, ""
Popup_Menu.ShowPopup pt.X, pt.Y
END SUB
SUB 填充颜色()
Clear_menu '清除弹出菜单上菜单项
Dim cmb As CommandBarControl
AddCustomCommandBarPopup1 "线条颜色 ", "bpbj61", False, True,300,""
AddCustomCommandBarPopup2 ("绘图与书写笔 ")
Set cmb = Application.CommandBars("CELL").Controls("绘图与书写笔 ")
AddCustomCommandBarPopup3 cmb, "批注笔 ", "bpbj63", False, True, 304, ""
Set cmb = Application.CommandBars("CELL").Controls("绘图与书写笔 ")
AddCustomCommandBarPopup3 cmb, "绘图和书写笔 ", "bpbj64", False, True, 306, ""
Set cmb = Application.CommandBars("CELL").Controls("绘图与书写笔 ")
AddCustomCommandBarPopup3 cmb, "注释笔 ", "bpbj65", False, True, 308, ""
Set cmb = Application.CommandBars("CELL").Controls("绘图与书写笔 ")
AddCustomCommandBarPopup3 cmb, "叠放次序 ", "bpbj66", False, True, 310, ""
Set cmb = Application.CommandBars("CELL").Controls("绘图与书写笔 ")
AddCustomCommandBarPopup3 cmb, "微移 ", "bpbj67", False, True, 312, ""
Set cmb = Application.CommandBars("CELL").Controls("绘图与书写笔 ")
AddCustomCommandBarPopup3 cmb, "对齐或分布 ", "bpbj68", False, True, 314, ""
AddCustomCommandBarPopup2 ("旋转或翻转 ")
Set cmb = Application.CommandBars("CELL").Controls("旋转或翻转 ")
AddCustomCommandBarPopup3 cmb, "直线 ", "bpbj70", False, True, 318, ""
Set cmb = Application.CommandBars("CELL").Controls("旋转或翻转 ")
AddCustomCommandBarPopup4 cmb, "连接符 "
Set cmb = Application.CommandBars("CELL").Controls("旋转或翻转 ").Controls("连接符 ")
AddCustomCommandBarPopup3 cmb, "自选图形 ", "bpbj72", False, True, 322, ""
Set cmb = Application.CommandBars("CELL").Controls("旋转或翻转 ").Controls("连接符 ")
AddCustomCommandBarPopup3 cmb, "标注 ", "bpbj73", False, True, 324, ""
Popup_Menu.ShowPopup pt.X, pt.Y
END SUB
SUB 流程图()
Clear_menu '清除弹出菜单上菜单项
Dim cmb As CommandBarControl
AddCustomCommandBarPopup1 "箭头总汇 ", "bpbj75", False, True,328,""
AddCustomCommandBarPopup1 "星与旗帜 ", "bpbj76", False, True,330,""
AddCustomCommandBarPopup1 "基本形状 ", "bpbj77", False, True,332,""
AddCustomCommandBarPopup1 "插入形状 ", "bpbj78", False, True,334,""
AddCustomCommandBarPopup2 ("形状 ")
Set cmb = Application.CommandBars("CELL").Controls("形状 ")
AddCustomCommandBarPopup3 cmb, "非活动图表 ", "bpbj80", False, True, 338, ""
Set cmb = Application.CommandBars("CELL").Controls("形状 ")
AddCustomCommandBarPopup3 cmb, "Excel 控件 ", "bpbj81", False, True, 340, ""
AddCustomCommandBarPopup1 "曲线 ", "bpbj82", False, True,342,""
AddCustomCommandBarPopup1 "曲线结点 ", "bpbj83", False, True,344,""
AddCustomCommandBarPopup1 "曲线段 ", "bpbj84", False, True,346,""
AddCustomCommandBarPopup1 "图片上下文菜单 ", "bpbj85", False, True,348,""
Popup_Menu.ShowPopup pt.X, pt.Y
END SUB
SUB OLE对象()
Clear_menu '清除弹出菜单上菜单项
Dim cmb As CommandBarControl
AddCustomCommandBarPopup1 "ActiveX 控件 ", "bpbj87", False, True,352,""
AddCustomCommandBarPopup1 "艺术字上下文菜单 ", "bpbj88", False, True,354,""
AddCustomCommandBarPopup1 "旋转方式 ", "bpbj89", False, True,356,""
AddCustomCommandBarPopup1 "连接符 ", "bpbj90", False, True,358,""
AddCustomCommandBarPopup1 "脚本标记快捷菜单 ", "bpbj91", False, True,360,""
AddCustomCommandBarPopup1 "Canvas Popup ", "bpbj92", False, True,362,""
AddCustomCommandBarPopup1 "Organization Chart Popup ", "bpbj93", False, True,364,""
AddCustomCommandBarPopup2 ("图表 ")
Set cmb = Application.CommandBars("CELL").Controls("图表 ")
AddCustomCommandBarPopup3 cmb, "选择 ", "bpbj95", False, True, 368, ""
Set cmb = Application.CommandBars("CELL").Controls("图表 ")
AddCustomCommandBarPopup4 cmb, "版式 "
Set cmb = Application.CommandBars("CELL").Controls("图表 ").Controls("版式 ")
AddCustomCommandBarPopup3 cmb, "符号栏 ", "bpbj97", False, True, 372, ""
Set cmb = Application.CommandBars("CELL").Controls("图表 ").Controls("版式 ")
AddCustomCommandBarPopup3 cmb, "任务窗格 ", "bpbj98", False, True, 374, ""
Popup_Menu.ShowPopup pt.X, pt.Y
END SUB
SUB 添加命令()
Clear_menu '清除弹出菜单上菜单项
Dim cmb As CommandBarControl
AddCustomCommandBarPopup1 "内置菜单 ", "bpbj100", False, True,378,""
AddCustomCommandBarPopup1 "剪贴板 ", "bpbj101", False, True,380,""
AddCustomCommandBarPopup1 "信封 ", "bpbj102", False, True,382,""
AddCustomCommandBarPopup1 "联机会议 ", "bpbj103", False, True,384,""
AddCustomCommandBarPopup1 "SnagIt ", "bpbj104", False, True,386,""
Popup_Menu.ShowPopup pt.X, pt.Y
END SUB
SUB 关于()
Clear_menu '清除弹出菜单上菜单项
Dim cmb As CommandBarControl
AddCustomCommandBarPopup1 "我的VBA ", "WDVBA", False, True,400,""
AddCustomCommandBarPopup1 "帮助 ", "BZ", False, True,402,""
Popup_Menu.ShowPopup pt.X, pt.Y
END SUB
Public Sub ClearBar() '清除Cell弹出式菜单中菜单项
Dim ctr As CommandBarControl
With Popup_Menu
.Enabled = True
For Each ctr In .Controls
ctr.Delete
Next
End With
End Sub
Sub RemoveCustomMenu() '恢复系统菜单的各弹出菜单
Application.CommandBars("CELL").Reset
End Sub
Sub clear_menu()
Dim cmb As Object
For Each cmb In Application.CommandBars("cell").Controls
Application.CommandBars("cell").Controls(cmb.Caption).Delete
Next
End Sub
Sub AddCustomCommandBarPopup1(Caption As String, Macro As String, NewGroup As Boolean, Enable As Boolean, FId As Integer, ShortT As String) '添加一级菜单选项
Dim cbb As CommandBarButton
Set cbb = Application.CommandBars("CELL").Controls.Add(msoControlButton)
cbb.Caption = Caption
If FId > 0 Then cbb.faceid = FId
If ShortT "" Then cbb.ShortcutText = ShortT
cbb.OnAction = Macro
cbb.BeginGroup = NewGroup
cbb.Enabled = Enable
End Sub
Function AddCustomCommandBarPopup2(Caption As String) As CommandBarControl '添加子菜单项
Dim cmb As CommandBarControl
Set cmb = Application.CommandBars("CELL").Controls.Add(msoControlPopup)
cmb.Caption = Caption
cmb.Visible = True
Set AddCustomCommandBarPopup2 = cmb
End Function
Sub AddCustomCommandBarPopup3(cmb As Object, Caption As String, Macro As String, NewGroup As Boolean, Enable As Boolean, FId As Integer, ShortT As String) '添加一级菜单选项
Dim cbc As CommandBarButton
Set cbc = cmb.Controls.Add(msoControlButton)
cbc.Caption = Caption
If FId > 0 Then cbc.faceid = FId
If ShortT "" Then cbc.ShortcutText = ShortT
cbc.OnAction = Macro
cbc.BeginGroup = NewGroup
cbc.Enabled = Enable
End Sub
Function AddCustomCommandBarPopup4(cmd As CommandBarControl, Caption As String) As CommandBarControl '添加子菜单项
Dim cme As CommandBarControl
Set cme = cmd.Controls.Add(msoControlPopup)
cme.Caption = Caption
cme.Visible = True
Set AddCustomCommandBarPopup4 = cme
End Function
'********本模块结束**********
'***************************
'* 窗口模块 *
'***************************
Private menu(1 To 50) As New Menu_Class '定义50个cMenu菜单类型
Private Sub UserForm_Initialize()
hForm = FindWindow(vbNullString, Me.Caption) '程序中需要用到窗口句柄,先获得它
MenuCount = 0
Set Popup_Menu = Application.CommandBars("Cell") '程序中需指定一个弹出式菜单,我们指定为单元格右键菜单,您可另外指定一个弹出式菜单,请注意,是弹出式菜单
Dim bar As Control
Set bar = Me.Controls.Add("Forms.image.1", "IM1", Visible)
With bar
.Visible = True
.Left = -100
.Top = 0
.Height = 20
.Width = 20
.BackColor = &HFFC0C0
.BorderStyle = 0
End With
'***************
Set bar = Me.Controls.Add("Forms.image.1", "IM2", Visible)
With bar
.Visible = True
.Left = -100
.Top = 0
.Height = 20
.Width = 20
.BackColor = &HFFC0C0
.BorderStyle = 0
End With
'***************
Set bar = Me.Controls.Add("Forms.image.1", "FormMenuBar", Visible)
With bar
.Visible = True
.Left = -1
.Top = -1
.Height = 20
.Width = 2000
.BackColor = &HFFC0C0
.BorderStyle = 0
End With
menu(1).AddMenu Me,"文件","文件",""
menu(2).AddMenu Me,"公式","公式",""
menu(3).AddMenu Me,"开发工具","开发工具",""
menu(4).AddMenu Me,"窗口","窗口",""
menu(5).AddMenu Me,"工具","工具",""
menu(6).AddMenu Me,"常用","常用",""
menu(7).AddMenu Me,"列表","列表",""
menu(8).AddMenu Me,"序列","序列",""
menu(9).AddMenu Me,"框架","框架",""
menu(10).AddMenu Me,"填充颜色","填充颜色",""
menu(11).AddMenu Me,"流程图","流程图",""
menu(12).AddMenu Me,"OLE对象","OLE对象",""
menu(13).AddMenu Me,"添加命令","添加命令",""
menu(14).AddMenu Me,"关于","关于",""
end sub
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
Dim i As Integer
For i = LBound(menu) To UBound(menu)
Set menu(i) = Nothing
Next
Popup_Menu.Enabled = True
Popup_Menu.Reset
end sub
'********本模块结束**********
本文介绍了如何使用Excel 2010 VBA动态创建窗体，详细讲解了VBComponents集合和VBComponent对象的使用，包括添加、设置属性、删除组件以及在VBA工程中显示窗体的方法。同时强调了安全设置的重要性。
最低0.47元/天 解锁文章
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
