Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I don't think you can have a .faceid for a commandbarpopup. Maybe you want a
commandBarButton instead???? Option Explicit Sub DummyMacro() Dim MenuObject As CommandBarButton Set MenuObject = Application.CommandBars(1). _ Controls.Add(Type:=msoControlButton, _ Befo=11, _ Temporary:=True) MenuObject.Caption = "Projects" MenuObject.FaceId = 17 MenuObject.Style = msoButtonIconAndCaption End Sub R Vaughn wrote: I am unable to run the following subroutine because of a compile error that flags the FaceId text in the last line of code ( "method or data member not found") Why? Sub DummyMacro() Dim MenuObject As CommandBarPopup Set MenuObject = Application.CommandBars(1). _ Controls.Add(Type:=msoControlPopup, _ Befo=11, _ Temporary:=True) MenuObject.Caption = "Projects" MenuObject.FaceId = 17 End Sub -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
VBAProject name compile error, not defined at compile time | Excel Programming | |||
error message: compile error, argument not optional | Excel Programming | |||
Error setting FaceId of CommandbarButton | Excel Programming |