LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default compile error with FaceId

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
help with this error-Compile error: cant find project or library JackR Excel Discussion (Misc queries) 2 June 10th 06 09:09 PM
VBAProject name compile error, not defined at compile time Matthew Dodds Excel Programming 1 December 13th 05 07:17 PM
error message: compile error, argument not optional Pierre via OfficeKB.com Excel Programming 3 September 5th 05 03:45 PM
Error setting FaceId of CommandbarButton [email protected] Excel Programming 3 January 12th 05 06:10 PM


All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"