CommandBar Button parameters

[Bill D.]

Thanks to Bernie and jmoffat for help with creating a Commandbar. Now, I
still have a problem.

Where can I find a list of the parameters for creating the buttons?

Bernie's button was:

With myButton
.Caption = "Hello"
.Style = msoButtonIcon
.FaceId = 137
.Enabled = True
.OnAction = "SayHello"
End With

I want a button to have both text and an icon and to run a macro when
clicked. I've tried wading through the help files looking for Style,
FaceID, etc but no where have I found a list of what controls what. I
assume a button with text and an icon will be
..Style=.msoButton(something)and the text will be the .Caption. I've
tried IconText, TextIcon but nothing changes. Also by randomly plugging
in nembers for FaceID I've foumd a lot of different icons. Is there a
list somewhere of faceID icons?

Sorry to keep bothering everyone with these elementary questions

Bill

There are 10 types of people; those that understand binary and those
that don't.

Remove NOTME to reply direct

 

[Beto]

in nembers for FaceID I've foumd a lot of different icons. Is there a
list somewhere of faceID icons?

Get the Face Identifier addin from John Walkenbach's page:

http://www.j-walk.com/ss/excel/files/developer.htm

Regards,

 

[Bob Phillips]

Bill,

You want .Style = msoButtonIconAndCaption, obvious eh?<vbg>

You can see the possibles by looking up the Style property in Help under
commandbar controls.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bill D.]

Beto, Thanks a big help.

Bob, Now it is.

Bill

There are 10 types of people; those that understand binary and those
that don't.

Remove NOTME to reply direct