Button face 2

[Tronsliver]

I'm trying to custom build my own face for a commandbar button. Can someone give me a simple example. Also is there a listing anywhere for each ID for a button. For example ID:=3 is the "save" button face. In one of my older excel books it gave the complete listing of these button faces but I can't find an updated list.

Here is the code I'm using (thanks Skip)

Public Sub AutoRunSheet1()

Set myBar = CommandBars.Add(Name:="ClearTools1", _
Position:=msoBarLeft, Temporary:=True)
myBar.Visible = True
Set myControl = myBar.Controls _
.Add(Type:=msoControlButton, ID:=3)
With myControl
.DescriptionText = "Calculates stuff"
.Caption = "Calculate"
.OnAction = "FindDelta"
End With

End Sub

 

[rmikesmith]

Tronsliver,

Check out the following Microsoft site for FaceID info:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno97ta/html/faceid.asp

Also, John Walkenback has a FaceID utility that comes on the companion CD to his "Excel 2000 Power Programming With VBA" book. An excellent resource, by the way.

Good Luck!

 

[Tronsliver]

rmikesmith,

Thank you for your response this is exactly what I was looking for. Monday morning when I retrieve my work e-mail I'll mkae sure I give you a star.

Thanks Again

 

[LSTAN]

Hi

You can download an copy of the FaceId Identifier from John Walkenbach at this link;

http://j-walk.com/ss/excel/tips/tip67.htm

It's very useful for identifying the ID of button images.

rgrds
LSTAN