专注收集记录技术开发学习笔记、技术难点、解决方案
网站信息搜索 >> 请输入关键词:
您当前的位置: 首页 > 其他开发语言

Office 2007中VBA开发遇到的有关问题

发布时间:2011-06-30 07:27:16 文章来源:www.iduyao.cn 采编人员:星星草
Office 2007中VBA开发遇到的问题
这是个右键菜单的函数。运行到oPopup.ShowPopup时会弹出如下错误。请问这是怎么回事?谢谢!

Public Sub ShowRightMenue()
  Dim oPopup As CommandBar
  Dim oSubMenu As CommandBarPopup
  Dim oMenuItem As CommandBarControl
   
  Cancel = True
   
On Error Resume Next

  CommandBars("myRightMenu").Delete

On Error GoTo 0

  Set oPopup = CommandBars.Add("myRightMenu", msoBarPopup)
   
  Set oSubMenu = oPopup.Controls.Add(msoControlPopup)
  oSubMenu.Caption = "一级子菜单1"
  Set oMenuItem = oSubMenu.Controls.Add(msoControlButton)
  oMenuItem.Caption = "菜单项1-1"
  Set oMenuItem = oSubMenu.Controls.Add(msoControlButton)
  oMenuItem.Caption = "菜单项1-2"
  Set oMenuItem = oSubMenu.Controls.Add(msoControlButton)
  oMenuItem.Caption = "菜单项1-3"

  Set oSubMenu = oPopup.Controls.Add(msoControlPopup)
  oSubMenu.Caption = "一级子菜单2"
  Set oMenuItem = oSubMenu.Controls.Add(msoControlButton)
  oMenuItem.Caption = "菜单项2-1"
  Set oMenuItem = oSubMenu.Controls.Add(msoControlButton)
  oMenuItem.Caption = "菜单项2-2"
  Set oMenuItem = oSubMenu.Controls.Add(msoControlButton)
  oMenuItem.Caption = "菜单项2-3"

  oPopup.ShowPopup  

  oPopup.Delete
End Sub





------解决方案--------------------


oPopup.ShowPopup

改成

Application.CommandBars("myRightMenu").ShowPopup

看看
友情提示:
信息收集于互联网,如果您发现错误或造成侵权,请及时通知本站更正或删除,具体联系方式见页面底部联系我们,谢谢。

其他相似内容:

热门推荐: