开发者

How to add icons to custom menu in excel - vba

I have created some custom menu referring "Custom Menu visible to one document in Excel". Now I want to add some icon开发者_StackOverflow社区s to each menu item. Either that may be system icons or some others. Please provide some solution.


use the .FaceID property. If you want to know what id to use, then download a FaceID Browser addin for excel. Example:

Set MenuItem = NewMenu.Controls.Add _
  (Type:=msoControlButton)
With MenuItem
    .Caption = "Save XML Data"
    .FaceId = 270
    .OnAction = "AskExportXml"
    .Enabled = True
End With
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜