CommandBar Button parameters


B

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
 
Ad

Advertisements

B

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)
 
Ad

Advertisements

B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top