VBA (Excel) 怎样实现类似ToolTipText 的功能
现在想实现VB中类似Tooltip的功能,就是说当鼠标移动到命令按钮上
会有相应的提示出现,请问除了用MouseMove事件外,有没有直接一点的方法
因为发现Excel中的命令按钮好像没有ToolTipText属性。
相关推荐
EXCEL VBA创建菜单代码
EXCEL VBA创建菜单的代码 Sub Creatxlsht() On Error Resume Next Application.CommandBars("xlsht").Delete Dim cbrCmdBar As CommandBar Dim strCBarName As String strCBarName = "xlsht" Set cbrCmdBar = Application.CommandBars.Add(Name:=strCBarName, Position:=msoBarPopup) Set SubMenu = CommandBars(strCBarName).Controls.Add(Type:=msoControlButton) With SubMenu .Caption = "数据维护中心" .TooltipText = "aa" .Style = msoButtonIconAndCaption .Tag = "bb" .FaceId = 9588 ' 9949 '2122 '1018 .Enabled = True .OnAction = "k" End With Set SubMenu = CommandBars(strCBarName).Controls.Add(Type:=msoControlButton) With SubMenu .Caption = "显示客户记录" .TooltipText = "aa" .Style = msoButtonIconAndCaption .Tag = "bb" .FaceId = 9584 ' 9949 '2122 '1018 .Enabled = True .OnAction = "xskujl" End With Set SubMenu = CommandBars(strCBarName).Controls.Add(Type:=msoControlButton) With SubMenu .Caption = "删除客户记录" .TooltipText = "aa" .Style = msoButtonIconAndCaption .Tag = "bb" .FaceId = 9585 ' 9949 '2122 '1018 .Enabled = True .OnAction = "Sckujl" End With
EXCEL VBA编程与实战
EXCEL定制化程序开发 使用于excel2010 VBA编程实战指导
Excel-VBA宏编程实例源代码-修改单元格右键快捷菜单.zip
Excel-VBA宏编程实例源代码-修改单元格右键快捷菜单.zip
加载宏材料
加载宏文件 做EXCEL VBA中的宏加载教程使用
2021-2022计算机二级等级考试试题及答案No.13639.docx
2021-2022计算机二级等级考试试题及答案No.13639.docx


